Convert a text file to a.CSV

[LED47]

How do I convert a text file to a.CSV file

[altenbach]

A CSV file is just plain text file with the convention that rows are separated by linebreaks and columns (typically) separated by commas.

What is the structure of your text file and what is the purpose of all this?

[LED47]

It's just the tab delimited measurement data file

[LED47 · Accepted solution]

I realize I just have to call it up in Excel, I was open you could give me just the extra bit where I would set it as a CSV file and save it

[altenbach · Accepted solution]

All you need to do is read it as a string, replace all tabs with commas, then save it again.

Of course excel has no problem also reading tab delimited files directly. I still don't see the purpose of all this. Using a comma as column delimiter could get problematic if you share it with someone in a location where the decimal delimiter is also a comma.

[crossrulz · Accepted solution]

---

@altenbach wrote:

Using a comma as column delimiter could get problematic if you share it with someone in a location where the decimal delimiter is also a comma.

---

It could also be a problem if you actually need a comma in a string value.

I'm with Altenbach. If all you need is something that can easily be opened by Excel, a tab delimited text file works just fine. I do it all the time.

[thols · Accepted solution]

And also, I've had people asking for CSV files, when they meant TAB-delimited. So make sure you have the requirements of the assignment correct before doing unnecessary work.

[LED47]

Okay thank you very much to everyone I think I understand now

[LED47]

My intention with the following:

Open a text file as a CSV:

Then save the CSV

Result opens in memory as a CSV... Actual saved file is not in the CSV format.

[crossrulz]

Did you not like the solutions you already got?