Visit Our UNIX and Linux User Community


Read data in XML file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Read data in XML file
# 1  
Old 09-10-2009
Question 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 them later.

Kindly guide me on how to do this.
Code:
<batch status-category="A1">
              <billing-provider-npi>1871606764</billing-provider-npi>
              <total-claims>155</total-claims>
              <total-charges>110048.85</total-charges>
              <claim status-category="A3">
                <error>
                  <error-message>Loop: 2010BC_LOOP Subscriber ID not found on payer file</error-message>
                  <error-record>NM1</error-record>
                  <error-field>09::0067</error-field>
                  <error-code>H241</error-code>
                  <field-contents>ZWP9901514901</field-contents>
                </error>
                <patient-control-no>02G21968276-1</patient-control-no>
                <service-from>20090825</service-from>
                <total-charges>662.00</total-charges>
                <insured-id>ZWP9901514901</insured-id>
              </claim>
              <claim status-category="A3">
                <error>
                  <error-message>Loop: 2010BC_LOOP Subscriber ID not found on payer file</error-message>
                  <error-record>NM1</error-record>
                  <error-field>09::0067</error-field>
                  <error-code>H241</error-code>
                  <field-contents>ZWP800999146</field-contents>
                </error>
                <patient-control-no>02G21968151-1</patient-control-no>
                <service-from>20090824</service-from>
                <total-charges>58.00</total-charges>
                <insured-id>ZWP800999146</insured-id>
              </claim>
              <claim status-category="A1">
                <patient-control-no>02G21983647-1</patient-control-no>
                <service-from>20090827</service-from>
                <total-charges>61.00</total-charges>
                <insured-id>ZWE88003319201</insured-id>
              </claim>

Expecting:
02G21968276-1|ZWP9901514901
02G21968151-1|ZWP800999146

PS: I'm trying to use the commands given in other threads too....
Advance thanks.

Regards,
Swami

Last edited by swame_sp; 09-10-2009 at 05:11 PM.. Reason: Added Exp res
# 2  
Old 09-10-2009
Try this:

Code:
awk -F"<|>" '
/patient-control/{printf("%s|", $3)}
/insured-id/{printf("%s\n", $3)}
' file

Regards
# 3  
Old 09-10-2009
awesome...

Wow, terrific.... Thanks Franklin52
BTW, I'm trying to learn how it works....

Previous Thread | Next Thread
Test Your Knowledge in Computers #486
Difficulty: Medium
After a computer program is loaded and setup, the operating system begins executing the instructions at the program's end point in reverse byte-execution mode.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

In PErl script: need to read the data one file and generate multiple files based on the data

We have the data looks like below in a log file. I want to generat files based on the string between two hash(#) symbol like below Source: #ext1#test1.tale2 drop #ext1#test11.tale21 drop #ext1#test123.tale21 drop #ext2#test1.tale21 drop #ext2#test12.tale21 drop #ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies

2. UNIX for Advanced & Expert Users

Shell Script to read XML tags and the data within that tag

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... (2 Replies)
Discussion started by: SmilePlease
2 Replies

3. 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

4. Shell Programming and Scripting

To read a flat file containing XML data

I have a file something like this:aaaa.xml content of the file is 0,<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <storeInformation xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <s> <BRANCH_NO>3061</BRANCH_NO> <BRANCH_NAME>GREEN EXPRESS</BRANCH_NAME> ... (4 Replies)
Discussion started by: kmanivan82
4 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

script to read XML file

Dear All, I have one log file and it contains lot of XML as below. ... (1 Reply)
Discussion started by: murtujak
1 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 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

9. 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