Adding quotes

[dtanner]

I have a list of equipment numbers like
MO531
MO532
....etc etc

Would like to convert them to read
'MO521','MO532', and so on.

Thanx in advance.
DT In order to prevent possible injury to yourself, or your computer, and to ensure readability, please do not smoke, eat, drink, spindle, bend, fold, staple, or mutilate this message.

 

[CaKiwi]

Hi dtanner,

You could use

{
  printf "\047" $0 "\047" ","
}

Hope this helps. CaKiwi

 

[dtanner]

Well that solved getting them all on one line but not the single quote. I get \047 instead of the '.

thanx
DT In order to prevent possible injury to yourself, or your computer, and to ensure readability, please do not smoke, eat, drink, spindle, bend, fold, staple, or mutilate this message.

 

[CaKiwi]

Mmmmm, what version of awk are you using? I you are on solaris you need to use nawk. If you are on an old version of some some flavour of unix you may need to get gawk. CaKiwi

 

[aigles]

Hi,

Try this :

{
if (NR > 1) printf "," ;
printf "'" $0 "'" ;
}
Jean Pierre.

 

[flogrr]

Right idea, but syntax wrong.

{
if (NR > 1) printf ","
printf ("'%s'", $0)
}END{printf "\n"}

This works now.

HTH


flogrr
flogr@yahoo.com