Shell script for XML code parsing. Post: 302520902

Sponsored Content

Top Forums Shell Programming and Scripting Shell script for XML code parsing. Post 302520902 by ctsgnb on Monday 9th of May 2011 02:09:47 PM

05-09-2011

Registered User

if this helps :

Code:

sed "s/<[^>]*>/#/g;s/##*/\n/g" infile.xml

Code:

$ sed "s/<[^>]*>/#/g;s/##*/\n/g" tst.xml

13-WY-8425-2
WY84252
F
0005
13
04/12/2012
282.00
131533
DAN CUTHBERT
(847)228-6620
N
N
01
001
20090824
0615882
PRIOVOLOS, TASOS &amp; SOFIA
18214 S SPRING MEADOWS DR
N
N

$

Before further selections (if you want to pipe it into the awk statement suggested by ahmed in #4), you can also :

Code:

sed "s/></>\n</g" tst.xml

Code:

# sed "s/></>\n</g" tst.xml
<RequestBillsRsp version="1.0">
<BillSummaryData>
<AgreementNumberFull>13-WY-8425-2</AgreementNumberFull>
<AgreementNumberAbbr>WY84252</AgreementNumberAbbr>
<LineOfBusiness>F</LineOfBusiness>
<CompanyCode>0005</CompanyCode>
<UniqDigit/>
<StateCode/>
<UnitID>13</UnitID>
<DueDate>04/12/2012</DueDate>
<BillAmount>282.00</BillAmount>
<StateAgentCode>131533</StateAgentCode>
<AgentName>DAN CUTHBERT</AgentName>
<AgentPhoneNumber>(847)228-6620</AgentPhoneNumber>
<PayableFlag>N</PayableFlag>
<ACHPayableFlag>N</ACHPayableFlag>
<BillROCode>01</BillROCode>
<PayableMessage>001</PayableMessage>
<BillDate>20090824</BillDate>
<SeqNum>0615882</SeqNum>
<PlcyDispName>PRIOVOLOS, TASOS &amp; SOFIA</PlcyDispName>
<MailingZipcode/>
<RiskDesc>18214 S SPRING MEADOWS DR</RiskDesc>
<AnyAmountPayableFlag>N</AnyAmountPayableFlag>
<ACHAnyAmountPayableFlag>N</ACHAnyAmountPayableFlag>
</BillSummaryData>
<AddressInfo>
<AddressOne/>
<AddressTwo/>
<City/>
<State/>
<Zip/>
</AddressInfo>
<PayerName/>
<messages rc="00"/>
</RequestBillsRsp>
#

Last edited by ctsgnb; 05-09-2011 at 03:21 PM..

This User Gave Thanks to ctsgnb For This Post:

ctsgnb

View Public Profile for ctsgnb

Find all posts by ctsgnb

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

XML parsing through shell scritps

Hi, Am new to scripting. :) Am trying to figure out whether can i use bash scripting to parse an xml file. Parsing is not just pulling out information according to the pattern but its more of a generic parsing. I should identify the xml hierarchy and pull out information accordingly. It's not a...

2. Shell Programming and Scripting

Parsing XML using Shell Script

Hello, I'm a starting shell scripter and no Perl knowledge. I've trying to do this for a while: I want to parse an XML file and get certain data out of it and write that data into a CSV file, all this using Shell Scripting (in Bash). Or Perl without any XML Parser/Interpreter (if possible). ...

3. Shell Programming and Scripting

XML parsing in a shell script.

Below is a XML I have... <?xml version="1.0" encoding="UTF-8" ?> <component xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:XXXXX-www-Install-Manifest manifest.xsd" xmlns="urn:qqqqq-Install-Manifest" name="OM" ...

4. Shell Programming and Scripting

Shell script for XML code parsing.

Please help me to create a shell script that can parse the below XML and send a string back adding all XML values.:) <RequestBillsRsp...

5. Shell Programming and Scripting

XML parsing using shell script

I have a xml file like this <bul:collectionStrategy name="strategy1"> <bul:collectionTemplateGroup name="15min group"/> <bul:collectionTemplateGroup name="hourly group"/> </bul:collectionStrategy> <bul:CollectionTemplateGroup name="hourly group" > ...

6. Shell Programming and Scripting

XML to Text file Parsing Using shell scripting

Hi folks, Need some help with XML to text file parsing , the following is the content of the XML File. <xn:SubNetwork id="SNJNPRZDCR0R03"> <xn:MeContext id="PRSJU0005"> <xn:VsDataContainer id="PRSJU0005"> <xn:attributes> ...

7. Shell Programming and Scripting

Parsing XML using shell script

Well, issue is i have to parse this script to get the VERSION: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> <plist version="1.0"> <dict> <key>CFBundleAllowMixedLocalizations</key> ...

8. Solaris

XML to Text file Parsing Using shell scripting

Hi, I want to parse an XML File using Shell Script preferably by using awk command, I/P file is : <gn:ExternalGsmCell id="016P3A"> <gn:attributes> <gn:mnc>410</gn:mnc> <gn:mcc>310</gn:mcc> <gn:lac>8016</gn:lac> ...

9. Shell Programming and Scripting

XML-Text Parsing Using shell scripting

HI Guys, I have to parse below xml file :- <xn:SubNetwork id="ONRM_ROOT_MO_R"> <xn:MeContext id="LP101"> <xn:ManagedElement id="1"> <xn:VsDataContainer id="1"> <xn:attributes> ...

10. Shell Programming and Scripting

Parsing custom data into xml in Shell

Hi , I have data as below in a text file { 'AAA' => { 'A1' => 'a1 comment', 'A2' => 'a2 comment' }, 'BBB' => { 'B1' => 'b1 comment' }, 'CCC' => { 'C1' => 'c1 comment', 'C2' => 'c2 comment', 'C3' => 'c3 comment' 'C4' => 'c4...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

XML parsing through shell scritps

Discussion started by: karthikvela

2. Shell Programming and Scripting

Parsing XML using Shell Script

Discussion started by: Kage Musha

3. Shell Programming and Scripting

XML parsing in a shell script.

Discussion started by: dashok.83

4. Shell Programming and Scripting

Shell script for XML code parsing.

Discussion started by: xtatic

5. Shell Programming and Scripting

XML parsing using shell script

Discussion started by: LavanyaP

6. Shell Programming and Scripting

XML to Text file Parsing Using shell scripting

Discussion started by: tech_frk

7. Shell Programming and Scripting

Parsing XML using shell script

Discussion started by: zorosinister

8. Solaris

XML to Text file Parsing Using shell scripting

Discussion started by: tech_frk

9. Shell Programming and Scripting

XML-Text Parsing Using shell scripting

Discussion started by: asavaliya

10. Shell Programming and Scripting

Parsing custom data into xml in Shell

Discussion started by: vivek d r