Visit Our UNIX and Linux User Community


script to read XML file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting script to read XML file
# 1  
Old 05-25-2011
script to read XML file

Dear All,

I have one log file and it contains lot of XML as below.


<methodCall><methodName>RefillTRequest</methodName><params><param><value><struct><member><name>originNodeType</name><value><string>EXT</string></value></member><member><name>originHostName</name><value><string>ABC_SRV01</string></value></member><member><name>originTransactionID</name><value><string>12345678998765432100</string></value></member><member><name>originTimeStamp</name><value><dateTime.iso8601>20110517T00:00:19+0400</dateTime.iso8601></value></member><member><name>subscriberNumber</name><value><string>123456789123</string></value></member><member><name>transactionAmountRefill</name><value><string>3150</string></value></member><member><name>transactionCurrency</name><value><string>DHS</string></value></member><member><name>paymentProfileID</name><value><string>ABC</string></value></member><member><name>externalData1</name><value><string>Service</string></value></member></struct></value></param></params></methodCall>
<methodCall><methodName>RefillTRequest</methodName><params><param><value><struct><member><name>originNodeType</name><value><string>EXT</string></value></member><member><name>originHostName</name><value><string>ABC_SRV01</string></value></member><member><name>originTransactionID</name><value><string>11223344556677889911</string></value></member><member><name>originTimeStamp</name><value><dateTime.iso8601>20110517T00:00:48+0400</dateTime.iso8601></value></member><member><name>subscriberNumber</name><value><string>987654321987</string></value></member><member><name>transactionAmountRefill</name><value><string>5250</string></value></member><member><name>transactionCurrency</name><value><string>DHS</string></value></member><member><name>paymentProfileID</name><value><string>ABC</string></value></member><member><name>externalData1</name><value><string>Service</string></value></member></struct></value></param></params></methodCall>

I want to generates CSV from above XML. CSV is as below.

MSISDN,Transaction ID ,Amount,Profile ID
123456789123,12345678998765432100,3150,ABC
987654321987,11223344556677889911,5250,ABC
# 2  
Old 05-25-2011
In simple way, without much intelligence,

Code:
$ awk -F "<string>|</string>" '{OFS=",";print $6,$8,$10,$14}' file
12345678998765432100,123456789123,3150,ABC
11223344556677889911,987654321987,5250,ABC

If you have more conditions, please list them.

Previous Thread | Next Thread
Test Your Knowledge in Computers #480
Difficulty: Easy
Memory addresses are represented using hexadecimal, which is a base-8 counting system.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Read xml file till script finds separation and run again for next input and so on

Hi All, I have one query, I managed to run script with user inputs through command line or with 1 file. But I need to read a txt file/xml file in which user can mention multiple sets of answers and script should run for each set till it reach the EOF. Thanks in advance for example, the file... (3 Replies)
Discussion started by: rv_champ
3 Replies

2. Red Hat

How to read an xml file through shell script?

Hey , can we read an xml file and make changes in it through shell script. Thanks (4 Replies)
Discussion started by: ramsavi
4 Replies

3. Shell Programming and Scripting

Shell Script to read XML file

Hi unix Gurus, I am really new to Unix Scripting. Please help me to create a shell script which reads the xml file and from that i need to fetch a particular information. For example <SOURCE BUSINESSNAME ="" DATABASETYPE ="Teradata" DBDNAME ="DWPROD3" DESCRIPTION ="" NAME... (5 Replies)
Discussion started by: SmilePlease
5 Replies

4. Shell Programming and Scripting

Read file excluding XML in it

Hi , I have a file like below.I want all the content in a single line excluding the XML.How can i proceed? t=21 y=23 rg=xyz ..... <xmlstarts> . . <xmlends> lk=99 lo=09 (3 Replies)
Discussion started by: chetan.c
3 Replies

5. Shell Programming and Scripting

Help on awk to read xml file

Hello, I have a xml file as shown below. I want to parse the file and store data in variables. xml file looks like: <TEST NAME="DataBaseurl">jdbc:oracle:thin:@localhost:1521:ora10</TEST> <TEST NAME="Databaseuser">Pradeep</TEST> ...... and many other such lines i want to read this file and... (2 Replies)
Discussion started by: pradeepmacha
2 Replies

6. Shell Programming and Scripting

Unix Script to read the XML file from Website

Hi Experts, I need a unix shell script which can copy the xml file from the below pasted website and paste in in my unix directory. http://www.westpac.co.nz/olcontent/olcontent.nsf/fx.xml Thanks in Advance... (8 Replies)
Discussion started by: phani333
8 Replies

7. Shell Programming and Scripting

read and write to xml file

hi i am quite new to shell scripting and need help in reading and writing in xml file i have an xml file with format: <main> <store> <name>ABC</name> <flag>0</flag> <size>123<size> </store> <store> <name>DEF</name> ... (2 Replies)
Discussion started by: kichu
2 Replies

8. Shell Programming and Scripting

Read data in XML file

Hello Everybody, I have a question on reading the data from XML file through KSH shell script. In the below file I need to collect the patient control no and its respective insured id. I need to have pair of these values in single line separated by some special character, so that I could use... (2 Replies)
Discussion started by: swame_sp
2 Replies

9. Shell Programming and Scripting

Read elements of a xml file??????

Hi, What is a good way to read elements of an xml file? i did try xmllint it doesnt provide a function to output values of a tree. In the below example when i specify from Family2 I need the name of the father then the output should be DAVE. Appreciate any help provided in this regards. Many... (6 Replies)
Discussion started by: ahmedwaseem2000
6 Replies

10. Shell Programming and Scripting

Read xml file

Iam new to shell script. How to read xmlfile using shellscript(without awk),and Store record by record in file . My xml file: <root> <header> <HeaderData1>header1</HeaderData1> <HeaderData2>header2</HeaderData2> </header> <detailsRecord> ... (2 Replies)
Discussion started by: ram2s2001
2 Replies

Featured Tech Videos