Shell Programming and Scripting

hello,

I have a file that have lines that contains xml tags. for each line, i want to retrieve the value from the following xml tags and output it to another file with the values only, comma seperated. what is the best way to do this? again, the string is all in 1 line one, though it has many tags.

input : get the values
-------------------------------
<TCRMService><ResponseControl><ResultCode>SUCCESS</ResultCode><ServiceTime>510</ServiceTime><DWLControl><requesterLanguage>100</requesterLanguage><requesterLocale>en</requesterLocale><requesterName>SITE_DM5_070710</requesterName><requestID>1018757</requestID></DWLControl></ResponseControl><TxResponse><RequestType>addCCMSSite</RequestType><TxResult><ResultCode>SUCCESS</ResultCode></TxResult><ResponseObject><TCRMExtension> <TCRMSiteBObj><ComponentID>1000634</ComponentID><SiteId>819128085544095729</SiteId><SitePartyId>S0030Y3ZL6</SitePartyId><ParentOrganizationPartyId>O000Z4M0W3</ParentOrganizationPartyId><MainSiteIndicator>N</MainSiteIndicator><HeadQuarterIndicator>Y</HeadQuarterIndicator><PreferLanguageType>400</PreferLanguageType><PreferLanguageValue>ä¸*文（简体）</PreferLanguageValue><MainBPSiteIndicator>N</MainBPSiteIndicator><ISUCodeType>1000013</ISUCodeType><ISUCodeValue>Global Midmarket Business</ISUCodeValue><DUNSNumber>654642826</DUNSNumber><SiteUsageType>1000001</SiteUsageType><SiteUsageValue>Sold To</SiteUsageValue><CustomerClassificationType>1000005</CustomerClassificationType><CustomerClassificationValue>Commercial Customer</CustomerClassificationValue><BPSiteIndicator>N</BPSiteIndicator><TCRMSiteLastUpdateDate>2010-08-03 17:10:40.957</TCRMSiteLastUpdateDate><TCRMSiteLastUpdateTxId>380128085544090107</TCRMSiteLastUpdateTxId><TCRMSiteLastUpdateUser>SITE_DM5_070710</TCRMSiteLastUpdateUser><DWLStatus><Status>0</Status></DWLStatus><TCRMExtension> <TCRMSiteNameBObj><ComponentID>1000683</ComponentID><SiteNameId>854128085544099140</SiteNameId>


output: to another file with this format.

Code:

1018757,SUCCESS,S0030Y3ZL6

please see attach response file for example. i'dl like to do this using either awk/sed or perl.

thank you much in advance.

Moderator's Comments:

Generally use code tags, ty.

try this,

Code:

perl -lne 'if ( /\<requestID\>(\d+)\<\/requestID\>(.+?)\<ResultCode\>(\w+)\<\/ResultCode\>(.+?)>\<SitePartyId\>(.+?)\<\/SitePartyId\>/ ) { print $1,",",$3,",",$5;}' response.xml

Not really correct, but just for your reference.

Code:

awk '{gsub(/></,">\n<")}1' response.xml|awk -F ">|<" '/requestID/||/SitePartyId/||/ResultCode/ {printf $3","}'

SUCCESS,1018757,SUCCESS,S0030Y3ZL6,

rdcwayx, thanks this might work for me: can you explain the code?

awk '{gsub(/></,">\n<")}1' response.xml|awk -F ">|<" '/requestID/||/SitePartyId/||/ResultCode/ {printf $3","}'

---------- Post updated at 04:56 PM ---------- Previous update was at 10:20 AM ----------

=====================================
I am beginning to understand,can you explain your code? I tried this on my system and it works. I even tried a few more attributes, which works but got really confused as to what all the syntax and commands are doing. Your explanation is greatly appreciated.

ie.

what is (.+?) and (\w+) mean?

ultimately, i'd like to put this in a script instead of running this on the command line. i could potentially expand this to 12 attributes which would be cumbersome on the command line. is there a way to put this in a shell script?

---------- Post updated at 05:06 PM ---------- Previous update was at 04:56 PM ----------

=============

I need to redirect the results to a new file with a new line for every input line that got processed. I tried the code, which is bringing back the correct values - but in the output, it is all in 1 single line. how do I insert a new line into the output for each record that got processed? ie.

output should like like this:

SUCCESS,1018757,SUCCESS,S0030Y3ZL6
SUCCESS,1018758,SUCCESS,S0030Y3ZL6
SUCCESS,1018759,SUCCESS,S0030Y3ZL6
SUCCESS,1018760,SUCCESS,S0030Y3ZL6

Also, I need to get rid of the first 'SUCCESS' so the actually output should look like this:

1018757,SUCCESS,S0030Y3ZL6
1018758,SUCCESS,S0030Y3ZL6
1018759,SUCCESS,S0030Y3ZL6
1018760,SUCCESS,S0030Y3ZL6

here is an example of a file that contains 2 records:

I need to pull out the following attributes:

1) requestID
2) ResultCode
3) SitePartyId
4) AddressUsageType ( this has multiple )
5) TransportZoneType ( this has multiple )

with this FINAL output:

1532890,SUCCESS,S0000009Y5,1001400,1000278,1001100,1000278
1532909,SUCCESS,S000010U81,1001100,1000278,1001400,1000278

Code:

awk '{gsub(/></,">\n<")}1' 2site.xml|awk -F ">|<" '
/<TCRMService>/{printf "\n"}
/requestID/||/ResultCode/||/SitePartyId/||/AddressUsageType/||/TransportZoneType/ {printf $3","}
END{printf "\n"}'|cut -d, -f2-

---------
rdcwayx, thank you very much!. this code works great. how can i put this in a shell script? I want to call this script whenever, the system generates the input file. Also, can you explain the code?