How to convert a text file to CSV using Bash

Question

I've a text file with thousand of lines in it (each line has an email address) and I'd like to convert those to a CSV file using bash. The problem is I'm not well versed with Bash, so not sure how to go about doing it.

Any suggestions?

EDIT: File example:

[email protected]
[email protected]
[email protected]
[email protected]

a file where every line is just an email address is already a CSV. is there additional information in each line? — user21926
– user21926, Commented Sep 11, 2015 at 12:57
@SeanBright are you sure? I've tried to use the file to import into Drupal and got an error — WagnerMatosUK
– WagnerMatosUK, Commented Sep 11, 2015 at 12:59

user21926 · Accepted Answer · 2015-09-11 13:02:55Z

1

This is ugly but it should work:

while read email; do echo '"'${email//\"/\"\"}'"'; done < inputfile.txt > output.csv

This escapes " with "" which is how CSVs are escaped in Excel land.

answered Sep 11, 2015 at 13:02

user21926

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert a text file to CSV using Bash

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related