[SOLVED] Issues with using SED to remove / in date field

magnusemail · 09-01-2011, 07:25 PM

Hello,

I would appreciate aan answer on the correct syntex to remove the / in a csv file in which each date field is in the format 31/08/2011 and is need in format 31082011

the csv file has multiple rows, with each row having a starting date column to which I need to remove the / , I think I should use SED to to this, however perhaps I have not undertstood how to escape the / to be able to make it work?

Many thanks
Magnus

weibullguy · 09-01-2011, 08:14 PM

Code:

sed -i 's@/@@g' filename.csv

Should work.

grail · 09-01-2011, 10:10 PM

Be careful with the above if there are slashes in other fields as well.

weibullguy · 09-01-2011, 10:29 PM

Quote:

Originally Posted by grail

Be careful with the above if there are slashes in other fields as well.

Good point. I was assuming only the date had slashes. This will delete only the first two slashes in the file

Code:

sed -e 's@/@@2' -e 's@/@@1' filename.csv > newfilename.csv