grep 5 line below using awk

nails January 28, 2011 at 18:18:28

a way ..... #!/bin/ksh awk ' BEGIN { FS="<" } # setting FS to < parses the last 2 lines correctly { if($0 ~ /swltId/) { ind=index($0, "swltId") # assume swltId string is at the end of the record printf("%s", substr($0, ind, length($0) )) } if($0 ~ /NumEULUsersPerCell/) { ind=index($0, "NumEULUsersPerCell") printf("%s", substr($0, ind, length($0) )) # skip 3 lines getline getline getline printf("%s%s", FS, $2) getline printf("%s%s", FS, $2) } } ' datafile.txt

Hi Nails , Thanks for your reply .. the script doesn't work correctly as I want .. 1) The output not include with swltId="xxxx" 2) The output shows only for one xml .. 3) I want the script to extract the information from hundreds over xml files from directory . emogthu2@santuas4n> ls -l total 100 -rw-r--r-- 1 emogthu2 nms 16275 Jan 28 04:38 X911561304_270111_2132.xml -rw-r--r-- 1 emogthu2 nms 16900 Jan 28 03: X911562362_110126_003817.xml -rwxrwxrwx 1 emogthu2 nms 508 Jan 31 09:42 lic.ksh -rw-r--r-- 1 emogthu2 nms 0 Jan 31 10:02 license.txt -rw-r--r-- 1 emogthu2 nms 16275 Jan 28 04:02 licensekeys.xml emogthu2@santuas4n> emogthu2@santuas4n> emogthu2@santuas4n> emogthu2@santuas4n> cat *.xml | ./lic.ksh <capacity>32<hardLimit>32emogthu2@santuas4n> ---- > Here is the result Thanks , Samroy

nails January 31, 2011 at 12:33:15

>> 1) The output not include with swltId="xxxx" I am not having a problem. In my example script, this is the output from the script which, I believe is what you asked for: swltId="URM321">NumEULUsersPerCell</description><capacity>32<hardLimit>32 Remember that awk is case sensitive, so swltId is different from swlid. >> 3) I want the script to extract the information from hundreds over xml files from directory . First, change the script to change to the directory where your xml files reside: cd <your directory> Second, you don't say, so I am assuming that the output goes to one file. Place a for loop around your awk script asking for all files ending in xml: rm -f outputfile for file in *.xml do # place your awk script here. # echo a line so there is a carriage return between output echo done >> outputfile All you have to do is change the input file name of the awk script. In my example, change } ' datafile.txt to } ' "$file"