please help to parse the line


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting please help to parse the line
# 1  
Old 05-10-2006
please help to parse the line

cp4 0 0 170.217.86.10.1421 170.217.86.8.53308 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.62948 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.62949 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.63814 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.65322 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.41119 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.11.41394 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.11.41396 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.11.41461 ESTABLISHED

what need to do is, take 170.217.86.11 this portion of the content and check the hostname and act on it.
please help me how can I dothat
i tried like |awk -F '{print $5\.$6}' but gave error.

thanks
# 2  
Old 05-11-2006
Using the below input file,
Code:
$ cat test
cp4 0 0 170.217.86.10.1421 170.217.86.8.53308 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.62948 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.62949 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.63814 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.65322 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.8.41119 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.11.41394 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.11.41396 ESTABLISHED
tcp4 0 0 170.217.86.10.1421 170.217.86.11.41461 ESTABLISHED

How about this:
Code:
$ awk '{print $5}' test|while read line; do
> echo ${line%\.*}
> done

or this:
Code:
$ while read junk1 junk2 junk3 junk4 ipadd restofjunk; do
> echo ${ipadd%\.*}
> done < test

This is done in ksh. Check the man page for the explaination.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Ksh: Read line parse characters into variable and remove the line if the date is older than 50 days

I have a test file with the following format, It contains the username_date when the user was locked from the database. $ cat lockedusers.txt TEST1_21062016 TEST2_02122015 TEST3_01032016 TEST4_01042016 I'm writing a ksh script and faced with this difficult scenario for my... (11 Replies)
Discussion started by: humble_learner
11 Replies

2. Shell Programming and Scripting

Parse the next line

If you have a file like this Mike Student:1:4 Boy Student:3:4 Girl :master Then Output is: Mike Student:1:4 Boy Student:3:4 Girl :master (7 Replies)
Discussion started by: invinzin21
7 Replies

3. Shell Programming and Scripting

Parse XML line

Hi I am having an xml file with lines like these <d name="T2tt_350_100" title="T2tt_012j_350_100_428p4_pPF_PU" add="1" color="4" ls="1" lw="2" normf="1" xsection="0.070152" EqLumi="94651.6"... (2 Replies)
Discussion started by: Alkass
2 Replies

4. Shell Programming and Scripting

Help with cut and parse the line

I have log file which contains 1000s of lines something like this. INFO |2010-08-29 14:23:37,078|SERIAL_ID=1283109816352|ST=2010-08-2914:23:36|DP_DEVICE=11.22.33.44:4420|TYPE=TransactionLo g|LOG_LEVEL=6|CLASS=Superior... (7 Replies)
Discussion started by: baraghun
7 Replies

5. Shell Programming and Scripting

Parse a line by a space

I am trying to show each word on a separate line, but read in all the words on one command line. Below is the code I have right now: read name MyString=$name name2=" " echo $MyString | awk -v ORS="" '{ gsub(/./,"&\n") ; print }' | \ while read char do if then ... (8 Replies)
Discussion started by: tvb2727
8 Replies

6. Shell Programming and Scripting

To parse the line

Hi, I have a line QMNAME(qmgrname) STATUS(RUNNING) Can u jus tell me how to only get the status field ? And also the value of the status whether it is running or not running. -- Thanks (2 Replies)
Discussion started by: julie_s
2 Replies

7. UNIX for Advanced & Expert Users

how do you parse 1 line at a time of file1 ie. line(n) each line into new file

File 1 <html>ta da....unique file name I want to give file=>343...</html> <html>da ta 234 </html> <html>pa da 542 </html> and so on... File 2 343 234 542 and so on, each line in File 1 one also corresponds with each line in File 2 I have tried several grep, sed, while .. read, do,... (4 Replies)
Discussion started by: web_developer
4 Replies

8. Shell Programming and Scripting

SED help (remove line::parse again::add line)

Aloha! I have just over 1k of users that have permissions that they shouldn't under our system. I need to parse a provided list of usernames, check their permissions file, and strip the permissions that they are not allowed to have. If upon the permissions strip they are left with no permissions,... (6 Replies)
Discussion started by: Malumake
6 Replies

9. Shell Programming and Scripting

please help to parse the line

cp4 0 0 170.217.86.10.1421 170.217.86.8.53308 ESTABLISHED tcp4 0 0 170.217.86.10.1421 170.217.86.8.62948 ESTABLISHED tcp4 0 0 170.217.86.10.1421 170.217.86.8.62949 ESTABLISHED tcp4 0 0 170.217.86.10.1421 ... (1 Reply)
Discussion started by: ajaya
1 Replies

10. Shell Programming and Scripting

How to parse a line?

I'm currenting trying to parse the out put of the following command. iostat -xtc -r |grep cmdk0 which produces the output cmdk0,0.2,0.0,1.2,0.0,0.0,0.0,39.7,0,0,0,0,0,0,0,99 I'm then trying to get the data to look like this: rw=0.2 ws=0.0 krs=1.2 kws=0.0 wait=0.0 actv=0.0... (2 Replies)
Discussion started by: edefoe
2 Replies
Login or Register to Ask a Question