Shell Programming and Scripting

Hello,
I would like to add " " in the last column of my file.
For example, I have:

Code:

"1";toto
"2";tata

I would like:

Code:

"1";"toto"
"2";"tata"

I tried :

Code:

awk 'BEGIN{FS=";"}$2="\""$2"\""'

and the result was:

Code:

"1";toto""

If you have any ideas, I would appreciate your help, thanks you!

Moderator's Comments:

Please use CODE tags as required by forum rules!

Surprising - I get

Code:

awk 'BEGIN{FS=";"}$2="\""$2"\""' file
"1" "toto"
"2" "tata"

To get the field separator right, try setting the output field sep.:

Code:

awk 'BEGIN{FS=OFS=";"}$2="\""$2"\""' file
"1";"toto"
"2";"tata"

Please be aware that above is a bit unorthodox in that it exploits awk default behaviour (print $0 if pattern is TRUE) with a pattern that is true by (sort of) coincidence. That can be done if you know exactly WHAT you are doing. Are you sure that this is the desired method / operation?

humf you are right, this work!

Thanks.

sed alternatives, for the second column

Code:

sed 's/[^;]\{1,\}/"&"/2' file

just for the last column as happens to be the case here:

Code:

sed 's/[^;]*$/"&"/' file

Sorry, removing Perl suggestion since awk was specifically mentioned in the post title...