Extracting value from a xml file using awk

Question

I have a text stream like this
<device nid="05023CA70900" id="1" fblock="-1" type="switch" name="Appliance Home" brand="Google" active="false" energy_lo="427" /> <device nid="0501C1D82300" id="2" fblock="-1" type="switch" name="TELEVISION Home" brand="Google" active="pending" energy_lo="3272" />
from which i would like an output like
05023CA70900@@1@@-1@@switch@@Appliance Home@@Google@@false@@427 0501C1D82300@@2@@-1@@switch@@TELEVISION Home@@Google@@pending@@3272
There are many lines in the input all of which are not writable.

How can we achieve this using awk or sed ?

Any reason you're parsing XML data using awk/sed? There are specialized tool for this. — anubhava
– anubhava, Commented Jul 16, 2013 at 9:52
Using a shell script in an embedded system have very limited resources for the same.i dont have access to any tools on such a barebone of a system. @anubhava — Rohan Majumdar
– Rohan Majumdar, Commented Jul 16, 2013 at 9:55

anubhava · Accepted Answer · 2013-07-16 10:05:29Z

1

Following awk should work:

awk -F '"' '$1 == "<device nid=" { printf("%s@@%s@@%s@@%s@@%s@@%s@@%s@@%s\n", 
                    $2, $4, $6, $8, $10, $12, $14, $16)}' file

PS: It is not always best approach to parse XML using awk/sed.

edited Jul 16, 2013 at 10:05

answered Jul 16, 2013 at 9:57

anubhava

790k67 gold badges603 silver badges671 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rohan Majumdar Over a year ago

Works like a charm my friend but just one little bit of help needed.Can we place a filter in awk itself which first detects if the line has a <device nid in the beginnig .Then it will suffice @anubhava

Vijay · Accepted Answer · 2013-07-16 12:43:51Z

Its very simple in perl . So why not use perl ?

perl -lne 'push @a,/\"([\S]*)\"/g;print join "@@",@a;undef @a' your_file

Sample tested:

> cat temp
<device nid="05023CA70900" id="1" fblock="-1" type="switch" name="Appliance Home" brand="Google" active="false"  energy_lo="427" />  
<device nid="0501C1D82300" id="2" fblock="-1" type="switch" name="TELEVISION Home" brand="Google" active="pending"  energy_lo="3272" />  
> perl -lne 'push @a,/\"([\S]*)\"/g;print join "@@",@a;undef @a' temp
05023CA70900@@1@@-1@@switch@@Google@@false@@427
0501C1D82300@@2@@-1@@switch@@Google@@pending@@3272
>

I dont have perl on my embedded device.But anyways thanks for the suggestion. @Vijay

Ed Morton · Accepted Answer · 2013-07-17 11:04:06Z

0

awk -F\" -v OFS="@@" '/^<device nid=/ { print $2, $4, $6, $8, $10, $12, $14, $16 }' file

or more generally:

awk -F\" '/^<device nid=/ {for (i=2;i<=NF;i+=2) printf "%s%s",(i==2?"":"@@"),$i; print ""}' file

To address your question in your comment: If you could have a tab in front of <device nid:

awk -F\" '/^\t?<device nid=// ...'

If you meant something else, update your question and provide more representative input.

edited Jul 17, 2013 at 11:04

answered Jul 16, 2013 at 12:33

Ed Morton

208k18 gold badges90 silver badges212 bronze badges

1 Comment

Rohan Majumdar Over a year ago

And if there is a tab in front of the "device nid".Can you please tell how to account for that. @Ed Morton

Collectives™ on Stack Overflow

Extracting value from a xml file using awk

3 Answers 3

1 Comment

1 Comment

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Related