How to parse a line?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to parse a line?
# 1  
Old 12-22-2005
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
svct=39.7
%w=0
%b=0
tin=0
tout=0
us=0
sy=0
wt=0
id=99

Any thoughts on how to do this would be great.
# 2  
Old 12-22-2005
Quote:
Originally Posted by edefoe
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
svct=39.7
%w=0
%b=0
tin=0
tout=0
us=0
sy=0
wt=0
id=99

Any thoughts on how to do this would be great.
iostat -xtc -r | nawk -F',' -v line='cmdk0' -f iostat.awk

iostat.awk:
Code:
FNR==2 {for(i=2; i<=NF;i++) header[i]=$i; next }
$1 == line { for(i=2; i<=NF;i++) printf("%s=%s\n", header[i], $i)}

I don't have your version of the iostat, so I could not test it thoroughly.

Last edited by vgersh99; 12-22-2005 at 03:22 PM..
# 3  
Old 12-22-2005
using perl split may be another option
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

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
Login or Register to Ask a Question