01-09-2006
ok..the file extracted is called outputrecord.txt and it contain this
2005-12-05 10:53:34,663 [ExecuteThread: '0' for queue: 'default'] INFO - etb is null
<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><func_c>C</func_c><vv_c>7701</vv_c><vessel_m>DEMO</vessel_m><abb
r_vessel_m>DEMO</abbr_vessel_m><voyage_out_n>1234</voyage_out_n><abbr_voyage_out_n>1234</abbr_voyage_out_n><voyage_in_n>1234</
voyage_in_n><abbr_voyage_in_n>1234</abbr_voyage_in_n><berth_seq_n>1</berth_seq_n><terminal_c> </terminal_c><old_terminal_c> </
old_terminal_c><position_from_n>0</position_from_n><position_to_n>0</position_to_n><wharfside_i> </wharfside_i><qc_rate_q>20.0
</qc_rate_q><qc_intensity_q>3.0</qc_intensity_q><location_from_c>AEW</location_from_c><location_to_c>SEAW</location_to_c><bert
h_pilot_i>true</berth_pilot_i><unberth_pilot_i>true</unberth_pilot_i><delay_c> </delay_c><status_c> </status_c><btr_dt>2005-12
-25T12:00:00.000+08:00</btr_dt><priority_c>C7</priority_c><scheme_qualify_i>X</scheme_qualify_i><section_n>-1</section_n></rec
ord>
2005-12-05 10:53:46,970 [ExecuteThread: '0' for queue: 'default'] INFO - etb is null
<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><func_c>C</func_c><vv_c>7686</vv_c><vessel_m>MSC ROBERTA</vessel
_m><abbr_vessel_m>MSC ROBERTA</abbr_vessel_m><voyage_out_n>2007EA</voyage_out_n><abbr_voyage_out_n>2007EA</abbr_voyage_out_n><
voyage_in_n>2007EA</voyage_in_n><abbr_voyage_in_n>2007EA</abbr_voyage_in_n><berth_seq_n>1</berth_seq_n><terminal_c> </terminal
_c><old_terminal_c> </old_terminal_c><position_from_n>0</position_from_n><position_to_n>0</position_to_n><wharfside_i>P</wharf
side_i><qc_rate_q>24.4</qc_rate_q><qc_intensity_q>2.9</qc_intensity_q><location_from_c>AEW</location_from_c><location_to_c>AEW
</location_to_c><berth_pilot_i>true</berth_pilot_i><unberth_pilot_i>true</unberth_pilot_i><delay_c> </delay_c><status_c> </sta
tus_c><btr_dt>2005-12-13T12:00:00.000+08:00</btr_dt><priority_c>C7</priority_c><scheme_qualify_i>X</scheme_qualify_i><section_
n>-1</section_n></record>
2005-12-05 10:53:56,734 [ExecuteThread: '0' for queue: 'default'] INFO - etb is null
<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><func_c>C</func_c><vv_c>7702</vv_c><vessel_m>MSC ROBERTA</vessel
_m><abbr_vessel_m>MSC ROBERTA</abbr_vessel_m><voyage_out_n>2007CC</voyage_out_n><abbr_voyage_out_n>2007CC</abbr_voyage_out_n><
voyage_in_n>2007KK</voyage_in_n><abbr_voyage_in_n>2007KK</abbr_voyage_in_n><berth_seq_n>1</berth_seq_n><terminal_c> </terminal
_c><old_terminal_c> </old_terminal_c><position_from_n>0</position_from_n><position_to_n>0</position_to_n><wharfside_i>P</wharf
side_i><qc_rate_q>24.4</qc_rate_q><qc_intensity_q>2.9</qc_intensity_q><location_from_c>AEW</location_from_c><location_to_c>AEW
</location_to_c><berth_pilot_i>true</berth_pilot_i><unberth_pilot_i>true</unberth_pilot_i><delay_c> </delay_c><status_c> </sta
tus_c><btr_dt>2005-12-20T14:00:00.000+08:00</btr_dt><priority_c>C7</priority_c><scheme_qualify_i>X</scheme_qualify_i><section_
n>-1</section_n></record>
and i try using the previous sed command which is this as im still not very good at writing sed codes....
i try using this:
sed -e 's_^..:..:.. .*<record_<record_g' outputrecord.txt > record_file
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Sorry to trouble you guys again.....but i encounter this problem:
My textfile contains this:
2006-01-12 01:12:08,290 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... (8 Replies)
Discussion started by: forevercalz
8 Replies
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
Hi,
I have the following code in my xml file:
<aaaRule loginIdPattern=".*"
orgIdPattern=".*" deny="false" />
<aaaRuleGroup name="dpaas">
<aaaRule loginIdPattern=".*" orgIdPattern=".*"
deny="false" />
I want to retrieve orgIdPattern and loginIdPattern parameter value based on... (2 Replies)
Discussion started by: mjavalkar
2 Replies
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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
6. Shell Programming and Scripting
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
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
8. Shell Programming and Scripting
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
9. UNIX for Beginners Questions & Answers
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