[CentOS] Formatting print with awk and ORS

Tue Jul 7 08:26:12 UTC 2009
John Doe <jdmls at yahoo.com>

From: Joseph L. Casale <JCasale at activenetwerx.com>
> I have a command I execute:
> awk 'BEGIN { ORS=" " } { print "\"" $1 "\"" }' input_file
> which gives me exactly what I need, all field one's in quotes on one line
> each separated by one space. I now need to print a single quote around all
> of this, but the ORS flag is screwing me up, it's causing every attempt I
> try to repeat for every record.

awk -v q="'" ' BEGIN { ORS=" "; printf("%s", q) } { print "\"" $1 "\"" } END { printf("%s", q) } '
or
awk ' BEGIN { ORS=" "; printf("\x27") } { print "\"" $1 "\"" } END { printf("\x27") } '

JD