Change txt file from 1 row to 1 column (1 Viewer)

[irish634]

I am not sure if this is even "doable," but I have the following task.

I have a comma separated txt file where all of the values are in one row and separated by commas. There are over 500 values. Why the output is like this is beyond me, but it is.

What I need to do is replace each comma with a carriage return so I can import this into excel (for charting purposes). I have a few hundred files to do.

Does anyone have an example of how to accomplish this?

Thank you,
Craig

 

[HiTechCoach]

Craig,

It is doable. Should not be very hard to do.

Before I post any code, I do have a question. DO you really just want a Carriage Return (CR) or do you really need a Carriage Return and Line Feed (CR + LF).

Note: Normally a a Carriage Return and Line Feed are used to terminate a line in Windows/MS DOS

 

[irish634]

Hi Boyd,

You are right, wasn't very hard. So no need to post any code. I always like to try to figure it out myself.

To answer your question, I used CR+LF.

Craig

 

[HiTechCoach]

Craig,

Glad to hear that you have a working solution!