G
Guest
I have a file that I create in Excel and save as CSV. It contains thousands
of rows and each row can end in a different column, so there are many rows
that have trailing commas that need to be removed.
I open the file in Word and run a macro where it replaces ",^p" with "^p" to
remove the commas and leave a paragraph marker at the end of each line.
The macro corrects 99% of the problem; however, it leaves random rows with
trailing commas. This forces visual review of the file to find these rows
and remove the commas manually. If I try to do a find and replace after
running the macro, Word doesn't recognize a ",^p" within the file, even
though I can turn on display of non-printable characters and see the comma
followed by the paragraph marker in each of these rows.
Any ideas on why it doesn't recognize some of these rows?
I wasn't sure to post this in Excel or Word since I can't figure out where
the problem originates.
Thanks for any help!
of rows and each row can end in a different column, so there are many rows
that have trailing commas that need to be removed.
I open the file in Word and run a macro where it replaces ",^p" with "^p" to
remove the commas and leave a paragraph marker at the end of each line.
The macro corrects 99% of the problem; however, it leaves random rows with
trailing commas. This forces visual review of the file to find these rows
and remove the commas manually. If I try to do a find and replace after
running the macro, Word doesn't recognize a ",^p" within the file, even
though I can turn on display of non-printable characters and see the comma
followed by the paragraph marker in each of these rows.
Any ideas on why it doesn't recognize some of these rows?
I wasn't sure to post this in Excel or Word since I can't figure out where
the problem originates.
Thanks for any help!