how to convert from CVS file to Carriage return seperated variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to convert a large CVS file into a Carriage Return Vairable
TXT file

CVS File Formate

A,B,C,112
A,B,e,124

File format required is

A
B
C
112

A
B,
e
124

and end up with TXT file ?
 
1. Open the CSV file in Word.
2. Do a Find/Replace. Find should be a comma ",". Replace should be
"^p".
3. Then File/Save As, and select Plain Text (* a .TXT) as the Save As Type.

if you need to have the blank line after each row, you need to insert a step
in my instructions above. So the full instructions would be as follows:

1. Open the CSV file in Word.
1a. Do a Find/Replace. Find should be a comma "^p". Replace should be
"^p^p".
2. Do a Find/Replace. Find should be a comma ",". Replace should be
"^p".
3. Then File/Save As, and select Plain Text (* a .TXT) as the Save As Type.

Let me know if you need more help.
 
Back
Top