awk output delimiters

casperdaghost · 10-23-2009, 04:58 AM

I want to change the output of the script - add delimeters - whether they are spaces, commas, dashes, tab spaces. whatever

I tired awk -F"delimeter" but that did not work

sh-3.00$ for i in $( grep cancel: ~casper/data/resource | grep ncs100 | awk "{ print $4 }'
do
echo $i
done
220774
230335
457674
532584
sh-3.00$

what I am looking to do is get :220774, 230335, 457674, 532584 or
or 220774 230335 457674 532584

I want to pass this output to another shell script with the $@ argument variable.

I tired awk -IFS already.

druuna · 10-23-2009, 05:05 AM

Hi,

Try setting the ORS (output record seperator).

To a space in the followinf example:
.....| grep ncs100 | awk "BEGIN { ORS = " "}{ print $4 }'

Hope this helps

casperdaghost · 10-23-2009, 05:27 AM

nice ORS - never heard of that one - just what I needs. arrrrgggggg!

casper@casper-laptop:~$ for i in $( ps auxwww | awk 'BEGIN { ORS= ","} { print $5 } ');
do
echo $i ;
done
3056,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2528,0,0,0,0,1780,1780,1780,1780,1780,2308,0,2012 ,
1940,3508,2992,2888,2888,6432,6324,16388,3364,5204,3436,3448,2296,3488

carters2 · 10-23-2009, 07:31 AM

gawk '{FS = "[:,-]+"} {print $3","$5}'

This will delimit on colon, comma, and dash and print two values with a comma between them

ghostdog74 · 10-23-2009, 08:17 AM

Quote:

Originally Posted by carters2

gawk '{FS = "[:,-]+"} {print $3","$5}'

This will delimit on colon, comma, and dash and print two values with a comma between them

put your FS in BEGIN block