how to get xml tag..


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting how to get xml tag..
# 1  
Old 01-12-2006
how to get xml tag..

Sorry to trouble you guys again.....but i encounter this problem:
My textfile contains this:
2006-01-12 01:12:08,290 [ExecuteThread: '1' for queue: 'default'] INFO - The XML message **************<PM_ARRIVAL xmlns:xsi=
"http://www.w3.org/2001/XMLSchemainstance"><system_c>GMS</system_c><trans_c>ARLC</trans_c></<PM_ARRIVAL>

2006-01-12 01:12:08,303 [ExecuteThread: '1' for queue: 'default'] INFO - Root Node is [PM_ARRIVAL]
2006-01-12 01:12:10,009 [ExecuteThread: '2' for queue: 'default'] INFO - message received...
2006-01-12 01:12:10,009 [ExecuteThread: '2' for queue: 'default'] INFO - The XML message **************<berth_allocation xmln
s:xsi="http://www.w3.org/2001/XMLSchemainstance"><system_c>BPMS</system_c><trans_c>BPMSMessage</trans_c><trans_dt>2006-01-12T01:12:09.601+08:00</trans_dt><message>&lt;record xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchemainstance&quot;&gt;&lt;</berth_allocation>
2006-01-12 01:12:10,015 [ExecuteThread: '2' for queue: 'default'] INFO - Root Node is [berth_allocation]
2006-01-12 01:12:10,021 [ExecuteThread: '2' for queue: 'default'] INFO - XML messages retrieved:<record xmlns:xsi="http://www
.w3.org/2001/XMLSchemainstance"><func_c>U</func_c><vv_c>20744</vv_c><vessel_m>BUNGATERATAIDUA</vessel_m><abbr_vessel_m>BTERATAI2</abbr_vessel_m><voyage_out_n>4101</voyage_out_n><abbr_voyage_out_n>4101</abbr_voyage_out_n></record>

2006-01-12 02:07:23,179 [ExecuteThread: '1' for queue: 'default'] INFO - message received...
2006-01-12 02:07:23,179 [ExecuteThread: '1' for queue: 'default'] INFO - The XML message **************<PM_EXIT xmlns:xsi="ht
tp://www.w3.org/2001/XMLSchemainstance"><system_c>GMS</system_c><trans_c>EXLC</trans_c><trans_dt>200601120206</trans_dt><user_id_m>PD$CYM</user_id_m></PM_EXIT>
2006-01-12 02:07:23,185 [ExecuteThread: '1' for queue: 'default'] INFO - Root Node is [PM_EXIT]
2006-01-12 02:08:19,633 [ExecuteThread: '2' for queue: 'default'] INFO - message received...
2006-01-12 02:07:23,185 [ExecuteThread: '1' for queue: 'default'] INFO - Root Node is [PM_EXIT]
2006-01-12 02:08:19,633 [ExecuteThread: '2' for queue: 'default'] INFO - message received...


I only want to get the PM_EXIT, PM_ARRIVAL and record tag which i highlighted in bold.
i can only get the record tag out with this sed command:
sed -n -e '/<record /{N;s_.*\(<record .*<\/record>\).*_\1_p;}' file.record.txt
however if i use for the PM_ARRIVAL and EXIT with this command i get
sed: command garbled: /<PM_EXIT /N;s_.*\(<PM_EXIT .*<\/PM_EXIT>\).*_\1_p;}..

any idea?
# 2  
Old 01-12-2006
Try...
Code:
awk -v X='(PM_ARRIVAL|record|PM_EXIT)' 'match($0,"<" X ".*" X ">"){print substr($0,RSTART,RLENGTH)}' file1

# 3  
Old 01-13-2006
hi.. i got this error when i try this code..
awk: syntax error near line 1
awk: bailing out near line 1
# 4  
Old 01-13-2006
Perhaps use nawk or gawk?
# 5  
Old 01-13-2006
thanks for your great help..erm can you explain to me the coding?? so that i can use that for further extraction of other xml files....
# 6  
Old 01-13-2006
Details of the awk match function can be found in the awk manual: Built-in Functions for String Manipulation
# 7  
Old 01-14-2006
thanks alot for the link! Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Grepping multiple XML tag results from XML file.

I want to write a one line script that outputs the result of multiple xml tags from a XML file. For example I have a XML file which has below XML tags in the file: <EMAIL>***</EMAIL> <CUSTOMER_ID>****</CUSTOMER_ID> <BRANDID>***</BRANDID> Now I want to grep the values of all these specified... (1 Reply)
Discussion started by: shubh752
1 Replies

2. Shell Programming and Scripting

Moving XML tag/contents after specific XML tag within same file

Hi Forum. I have an XML file with the following requirement to move the <AdditionalAccountHolders> tag and its content right after the <accountHolderName> tag within the same file but I'm not sure how to accomplish this through a Unix script. Any feedback will be greatly appreciated. ... (19 Replies)
Discussion started by: pchang
19 Replies

3. Shell Programming and Scripting

Help with missing XML tag

Hello All, I am struggling with many huge XML files with lots of Account details including at least one Membership tag, in that Membership tag one xml tag was missed that is MembershipIdentifier: (There are many Account tags with at least one Membership tag are there in each file) ...... ... (4 Replies)
Discussion started by: VasuKukkapalli
4 Replies

4. Shell Programming and Scripting

To search for a particular tag in xml and collate all similar tag values and display them count

I want to basically do the below thing. Suppose there is a tag called object1. I want to display an output for all similar tag values under heading of Object 1 and the count of the xmls. Please help File: <xml><object1>house</object1><object2>child</object2>... (9 Replies)
Discussion started by: srkmish
9 Replies

5. Shell Programming and Scripting

Need to replace XML TAG

As per the requirement I need to replace XML tag with old to new on one of the XML file. Old<com : DEM>PHI</com : DEM> New<com : DEM>PHM</com : DEM> Please someone provide the sed command to replace above mentioned old XML tag with new XML tag (2 Replies)
Discussion started by: siva83
2 Replies

6. Shell Programming and Scripting

XML Parse between to tag with upper tag

Hi Guys Here is my Input : <?xml version="1.0" encoding="UTF-8"?> <xn:MeContext id="01736"> <xn:VsDataContainer id="01736"> <xn:attributes> <xn:vsDataType>vsDataMeContext</xn:vsDataType> ... (12 Replies)
Discussion started by: pareshkp
12 Replies

7. Shell Programming and Scripting

How to add the multiple lines of xml tags before a particular xml tag in a file

Hi All, I'm stuck with adding multiple lines(irrespective of line number) to a file before a particular xml tag. Please help me. <A>testing_Location</A> <value>LA</value> <zone>US</zone> <B>Region</B> <value>Russia</value> <zone>Washington</zone> <C>Country</C>... (0 Replies)
Discussion started by: mjavalkar
0 Replies

8. Shell Programming and Scripting

How to retrieve the value from XML tag whose end tag is in next line

Hi All, Find the following code: <Universal>D38x82j1JJ </Universal> I want to retrieve the value of <Universal> tag as below: Please help me. (3 Replies)
Discussion started by: mjavalkar
3 Replies

9. Shell Programming and Scripting

XML tag replacement from different XML file

We have 2 XML file 1. ORIGINAL.xml file and 2. ATTRIBUTE.xml files, In the ORIGINAL.xml we need some modification as <resourceCode>431048</resourceCode>under <item type="Manufactured"> tag - we need to grab the 431048 value from tag and pass it to database table in unix shell script to find the... (0 Replies)
Discussion started by: balrajg
0 Replies

10. Shell Programming and Scripting

getting multiple xml tag

sorry for the trouble...... i have this file that contains the following: 00:00:21 Queue key, Queue Name= 00:00:21 Sending Message :<EXGC-EXGU xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <trans_id>EXGC</trans_id> <sys_prefix>GSYS</sys_prefix> ... (3 Replies)
Discussion started by: forevercalz
3 Replies
Login or Register to Ask a Question