[SOLVED] How to make a column in a CSV file lowercase from terminal?

ingram87 · 08-08-2012, 12:31 AM

How do you make an entire column (and only a single column) from a CSV file lowercase from the command line? I can do this easily in Writer, but I have a large number of CSV's and it would take to long to do it manually. Here is an example of my CSV file:

Code:

1,Roger,TALL,34,
2,Janice,SHORT,22,
3,Matt,TALL,18,

I would like to make the 3rd column (tall,short) lowercase.
Any help would be appreciated!

EricTRA · 08-08-2012, 12:39 AM

Hello,

You can do that with awk. I'm still in the learning process so others might provide another (shorter solution) but this one works. I saved your example in test.csv and redirected output in testout.csv.

Code:

awk -F',' '{ print $1","$2","tolower($3)","$4; }' < test.csv > testout.csv

Hope it helps.

Kind regards,

Eric

ingram87 · 08-08-2012, 01:01 AM

Quote:

Originally Posted by EricTRA

Hello,

You can do that with awk. I'm still in the learning process so others might provide another (shorter solution) but this one works. I saved your example in test.csv and redirected output in testout.csv.

Code:

awk -F',' '{ print $1","$2","tolower($3)","$4; }' < test.csv > testout.csv

Hope it helps.

Kind regards,

Eric

Thanks, that's exactly what I was looking for

EricTRA · 08-08-2012, 01:09 AM

Hi,

Glad it helps. Thanks for marking the thread as solved. Have fun with Linux.

Kind regards,

Eric