Putting Double Quotes in a text file

[Kurtkarl]

Hi,

I'm not sure if this was asked before But I tried searching the forum and could'nt find one. Anyways, I have a txt file and wanted to put a double quotes on every numbers within the column. Example

THis is the original file
201,303,412,484,576
202,306,413,485,578

and I want it to be as this one
"201","303","412","484","576"
"202","306","413","485","578"

Your help would be greatly appreciated
THanks
Joey

[Rodney Hills · Accepted solution]

You can use sed

sed -e 's/,/","/;s/^/"/;s/$/"/' outfile

-- Rod Hills

[Rodney Hills]

oops- I forgot the "g" option on the first "s" command.

sed -e 's/,/","/g;s/^/"/;s/$/"/' outfile

-- Rod Hills

[harry d brown jr]

cat infile | sed "s/\([0-9]\{3\}\)/\"\1\"/g" > outfile


live free or die
harry

[Roger Baptiste]

hi,

Same thing can be done via vi editor.
In escape mode:
%s/,/","/g
%s/^/"/
%s/$/"/

HTH
raj

[harry d brown jr]

If your numbers vary, as in


201,303,888412,484,576
101,403,712,884,9999876,3,44

then this will work:

cat infile | sed "s/\([0-9]\{1,\}\)/\"\1\"/g"


producing this:

"201","303","888412","484","576"
"101","403","712","884","9999876","3","44"


live free or die
harry

[SHABU KHAN]

Hi Joey,

Here is another way with sed:

This will prefix and suffix any number of numeric characters with double quotes:

sed 's/[0-9]*/"&"/g' filename


Thanks,
Shabu

[Rodney Hills]

Shabu,

Use of "*" matches null to, so you need to modify your sed with-

sed 's/[0-9]\{1,\}/"&"/g'

-- Rod Hills

[H.Merijn Brand (procura]

Without using a second file, altering the file itself in one sweep:

perl -pi -e 's/\d+/"$&"/g' file

[SHABU KHAN]

Thanks Rodney for pointing it out ...

Joey,
This will also match blanks as mentioned by Rodney "*" matches null also... Thanks for the points.

N/A for this please ..

-Shabu