topic Re: Awk Question in Operating System - HP-UX

Awk Question

Filosofo — Thu, 18 Sep 2003 10:28:07 GMT

Hi,
I have make a script where I want print all fields separate from a , .
I don't know hoe mach fields there are.
This is a script

cat try.out |while read line
do
line1=`echo $linea |awk 'BEGIN {OFS=","}
{for(i=1;i<=NF;i++)print $i}'`
echo $line1
done

but when I see the output I don't see , between the fields.

Please help

Filo

Re: Awk Question

Mark Grant — Thu, 18 Sep 2003 10:49:53 GMT

Hi,

It would be simpler to use "printf" which prints formatted text as in

printf "%s,",$i

which will print $i followed by a comma

Re: Awk Question

Jean-Luc Oudart — Thu, 18 Sep 2003 10:53:37 GMT

or simply : print $i,","
Rgds,
JL

Re: Awk Question

Peter Nikitka — Fri, 19 Sep 2003 12:25:46 GMT

Hi,

dont't know exactly what you need, but look at this:
echo 'a b c\nd\te f' |
awk -v ORS=, '{for(i=1;iprintf($NF"\n")}'

gives the following output:
a,b,c
d,e,f

So try
awk -v ORS=, '{for(i=1;iprintf($NF"\n")}' try.out

There is no need for cat and Shell-variables.

mfG Peter

Re: Awk Question

Leif Halvarsson_2 — Fri, 19 Sep 2003 13:15:34 GMT

Hi,
If I undrrstend you correct the fields is separated with spaces and you want output separated with commas. Why not use tr.
Try:
echo "ddd GGG" |tr " " ","

Re: Awk Question

Kent Ostby — Fri, 19 Sep 2003 13:24:55 GMT

Cleanest way is to create a file called try.awk:

{for (idx=1;idx {printf("%s,",$idx)}
printf("%s\n",$NF);
}

Then run it in your script as:

awk -f try.awk < try.out > outputfile

Re: Awk Question

Peter Nikitka — Fri, 19 Sep 2003 13:54:50 GMT

Hi Leif,

consider multiple spaces and TABs seperating fields, or white space at the beginning or at the end of a line ... . 'tr' won't do it, then.

mfG Peter