topic Re: separate out the column in Operating System - HP-UX

separate out the column

hanyyu1 — Thu, 22 Dec 2005 03:17:40 GMT

I know "awk -F:" will separate out the column by ":" , now if I what to separate out the column by space also , what can I do ?

for example :

#ps -ef |grep telnet
root 10159 702 0 15:45 ? 00:00:00 in.telnetd: 192.168.0.1

how to separate out the column so that the column as below,

column 1 --> root
column 2 --> 10159
column 3 --> 702
column 4 --> 0
column 5 --> 15
column 6 --> 45
column 7 --> ?
column 8 --> 00
column 9 --> 00
column 10 --> 00
column 11 --> in.telnetd
column 12 --> 192.168.0.1

|awk {print $12} then output the result is 192.168.0.1

Re: separate out the column

RAC_1 — Thu, 22 Dec 2005 03:30:08 GMT

ps -ef |grep telnet | awk -f " " '{print $whatyouwant}'

Re: separate out the column

Arunvijai_4 — Thu, 22 Dec 2005 03:33:07 GMT

ps -ef|grep -i telnet |awk 'BEGIN { FS = "[ \t\n]+" }{ print $x }'

-Arun

Re: separate out the column

hanyyu1 — Thu, 22 Dec 2005 03:47:34 GMT

thx replies ,

may be my question is not clear , what I want is to separate the column , to let the column is separate by : and space at the same time like my above example , is it possible ? thx

Re: separate out the column

RAC_1 — Thu, 22 Dec 2005 04:26:31 GMT

Seperate it by space first and then by :
ps -ef|grep telnet | awk -F " " '{print $whatyouwant}'|awk -F : ' {print $whatyouwant}'

Re: separate out the column

Muthukumar_5 — Thu, 22 Dec 2005 04:29:11 GMT

First split with -F" " that is default one. Then split with split() in awk as,

echo "root 10159 702 0 15:45 ? 00:00:00 in.telnetd: 192.168.0.1" | awk '{ split($5,a,":");split($7,b,":");print $1,$2,$3,$4,a[1],a[2],$6,b[1],b[2],b[3],$8,$9,$10,$11,$12; }'

-Muthu

Re: separate out the column

Muthukumar_5 — Thu, 22 Dec 2005 04:37:44 GMT

Another way as,

# ps -ef | grep 'telnet' | perl -an -F/:/ -e 'BEGIN{$,=" ";}{print @F;}'

-Muthu

Re: separate out the column

Arunvijai_4 — Thu, 22 Dec 2005 04:44:03 GMT

ps -ef | grep "telnet"|awk -F " " '{print $x }'|awk -F : ' {print $x}'

-Arun

Re: separate out the column

Rodney Hills — Thu, 22 Dec 2005 10:26:30 GMT

The -F option of awk allows for a regular expression, so you could use-

ps -ef | grep telnet | awk -F"[ :]" '{print $12}'

HTH

-- Rod Hills

Re: separate out the column

Peter Godron — Thu, 22 Dec 2005 11:03:40 GMT

echo "root 10159 702 0 15:45 ? 00:00:00 in.telnetd: 192.168.0.1" | awk '{ print $1,"\n",$2,"\n",$3,"\n",$4,"\n",$5,"\n",$6,"\n",$7,"
\n",$8,"\n",$9,"\n",$10,"\n",$11,"\n",$12; }'

Re: separate out the column

hanyyu1 — Fri, 23 Dec 2005 02:05:22 GMT

thx replies,

I tried the below script , but it will separate the column by space THEN seperate by : , if I want it will seperate by both space and : , what can I do ? thx

ps -ef | grep "telnet"|awk -F " " '{print $x }'|awk -F : ' {print $x}'

Re: separate out the column

Muthukumar_5 — Fri, 23 Dec 2005 02:47:59 GMT

You can not use two delimiters with -F option awk at one time. Select one delimiter and split it again with the next delimiter.

-Muthu