csv file modification

srinureddy · 10-31-2014, 05:38 AM

Hi.. i am new to the Linux. i have a task like this

i have a csv file like this

"101","ddd","ss"
"102","ssa","dee"
"103","dss"Ds","dsd"sds"
"104","sd"sds","dsds"
"105","dsd","dsdS"

in this i want to replace double quotes with 2 double quotes.

note: in this we used comma as a column delimiter and every column data enclosed by double quotes so we replace only only data contain double quotes.

ex:

"104","sd"sds","dsds"

i want to change li this

"104","sd""sds","dsds"

rtmistler · 10-31-2014, 06:36 AM

You can use sed for this:

Code:

sed s/\"/\"\"/g

eklavya · 10-31-2014, 07:49 AM

Try this for single double quote with two double quotes replacement.

Code:

sed -e 's/^\"/\x98/g' -e 's/\"$/\x98/g' -e 's/\",\"/\x99/g' -e 's/\"/\"\"/g' -e 's/\x99/\",\"/g' -e 's/\x98/\"/g' filename.csv

John VV · 10-31-2014, 06:37 PM

or even any text editor like gedit or kate

and use the find/replace option
you can even use a spreed sheet program like Openoffices "calc" ( aka Excel )

depending on the size of the file
for small files a spread sheet works great
for large files 10's of megs or gigs in size "sed" is great

grail · 10-31-2014, 09:57 PM

Maybe try and ask a question just once and don't open another because the other one is not going the direction you want.