UNIX for Dummies Questions & Answers

A Triva question.

What is the easy way to remove the double quotes in the file in the following format.

"asdfa","fdgh","qwer"

This need to be handled in a script. Any better way to do this. Will sed be more effecient?

One more question, If I come to know, " by itself a valid character in a field, I plan to remove "," and replace with , and in addition to that, first and last ".
May I know how to achieve this?

sed s/\"//g data1.txt
note that the normal format is sed s/old/new/g
one needs to use a \ character before certain special characters to keep them from being interpreted.

An example follows:

Code:

> cat data1.txt
"asdfa","fdgh","qwer"

> sed s/\"//g data1.txt
asdfa,fdgh,qwer

Thanks!!
Any inputs on replacing [","] with [,] and removing ["] at the start and end?

Looks like you want to parse a CSV file. Try this:

Code:

$ str='"One","He said "I love *nix"","end"'
$ echo $str
> "One","He said "I love *nix"","end"

$ echo $str | sed 's/","/,/g; s/^"\|"$//g'
> One,He said "I love *nix",end