Shell Programming and Scripting

sorry to trouble u guys again...
i have this document here called record.txt and it contains this:
2005-12-05 10:53:17,551 [ExecuteThread: '0' for queue: 'default'] INFO - message received...
2005-12-05 10:53:17,557 [ExecuteThread: '0' for queue: 'default'] INFO - The XML message **************<berth_allocation xmln
s:xsi="http://www.w3.org/2001/XMLSchema-instance"><system_c>BPMS</system_c><trans_c>BPMSMessage</trans_c><trans_dt>2005-12-05T
10:55:07.324+08:00</trans_dt><message>&lt;record xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-ins...&gt;&lt;func_c
&gt;C&lt;/func_c&gt;&lt;vv_c&gt;7688&lt;/vv_c&gt;&lt;vessel_m&gt;MSC ROBERTA&lt;/vessel_m&gt;&lt;abbr_vessel_m&gt;MSC ROBERTA&
lt;/abbr_vessel_m&gt;&lt;voyage_out_n&gt;90A&lt;/voyage_out_n&gt;&lt;abbr_voyage_out_n&gt;90A&lt;/abbr_voyage_out_n&gt;&lt;voy
age_in_n&gt;90A&lt;/voyage_in_n&gt;&lt;abbr_voyage_in_n&gt;90A&lt;/abbr_voyage_in_n&gt;&lt;berth_seq_n&gt;1&lt;/berth_seq_n&gt
;&lt;terminal_c&gt; &lt;/terminal_c&gt;&lt;old_terminal_c&gt; &lt;/old_terminal_c&gt;&lt;position_from_n&gt;0&lt;/position_fro
m_n&gt;&lt;position_to_n&gt;0&lt;/position_to_n&gt;&lt;wharfside_i&gt;P&lt;/wharfside_i&gt;&lt;qc_rate_q&gt;24.4&lt;/qc_rate_q
&gt;&lt;qc_intensity_q&gt;2.9&lt;/qc_intensity_q&gt;&lt;location_from_c&gt;P21&lt;/location_from_c&gt;&lt;location_to_c&gt;P21
&lt;/location_to_c&gt;&lt;berth_pilot_i&gt;true&lt;/berth_pilot_i&gt;&lt;unberth_pilot_i&gt;true&lt;/unberth_pilot_i&gt;&lt;de
lay_c&gt; &lt;/delay_c&gt;&lt;status_c&gt; &lt;/status_c&gt;&lt;btr_dt&gt;2005-12-13T13:00:00.000+08:00&lt;/btr_dt&gt;&lt;prio
rity_c&gt;C7&lt;/priority_c&gt;&lt;scheme_qualify_i&gt;X&lt;/scheme_qualify_i&gt;&lt;section_n&gt;-1&lt;/section_n&gt;&lt;/rec
ord&gt;</message><user_id_n>BA</user_id_n></berth_allocation>
2005-12-05 10:53:17,615 [ExecuteThread: '0' for queue: 'default'] INFO - Root Node is [berth_allocation]
2005-12-05 10:53:17,626 [ExecuteThread: '0' for queue: 'default'] INFO - XML messages retrieved:<record xmlns:xsi="http://www
.w3.org/2001/XMLSchema-instance"><func_c>C</func_c><vv_c>7688</vv_c><vessel_m>MSC ROBERTA</vessel_m><abbr_vessel_m>MSC ROBERTA
</abbr_vessel_m><voyage_out_n>90A</voyage_out_n><abbr_voyage_out_n>90A</abbr_voyage_out_n><voyage_in_n>90A</voyage_in_n><abbr_
voyage_in_n>90A</abbr_voyage_in_n><berth_seq_n>1</berth_seq_n><terminal_c> </terminal_c><old_terminal_c> </old_terminal_c><pos
ition_from_n>0</position_from_n><position_to_n>0</position_to_n><wharfside_i>P</wharfside_i><qc_rate_q>24.4</qc_rate_q><qc_int
ensity_q>2.9</qc_intensity_q><location_from_c>P21</location_from_c><location_to_c>P21</location_to_c><berth_pilot_i>true</bert
h_pilot_i><unberth_pilot_i>true</unberth_pilot_i><delay_c> </delay_c><status_c> </status_c><btr_dt>2005-12-13T13: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>

i need to get the bold xml tag out.......and its a large set of data...heres only a sample of a part...i need the <record> tag out...
i have trouble getting the xml tag and i have try this command but it doesnt work for me
i tried this :sed -e '/record/ !d' -e 's!<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">\([^<]*\)</record>!\1!' $file > getrecord.txt

is the entire record on one line ?
if yes try this sed 's/\<record.*\<\/record\>//g' filename > outfile

Code:

[/tmp]$ sed -n -e '/<record /{
N;
s_.*\(<record .*<\/record>\)_\1_p
}' in.txt

i got this problem :[/tmp]$: not found

linuxpenguin..i tried your code...but it doesnt work too..

The command is as simple as

Code:

sed -n -e '/<record /{N;s_.*\(<record .*<\/record>\)_\1_p;}' in.txt

[/tmp] $ is the prompt

Vino

thanks for the coding......
however the output still contains a line that i need to delete..any idea?
<record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><func_c>C</func_c><vv_c>7688</vv_c><vessel_m>MSC ROBERTA</vessel
_m><abbr_vessel_m>MSC ROBERTA</abbr_vessel_m><voyage_out_n>90A</voyage_out_n><abbr_voyage_out_n>90A</abbr_voyage_out_n><voyage
_in_n>90A</voyage_in_n><abbr_voyage_in_n>90A</abbr_voyage_in_n><berth_seq_n>1</berth_seq_n><terminal_c> </terminal_c><old_term
inal_c> </old_terminal_c><position_from_n>0</position_from_n><position_to_n>0</position_to_n><wharfside_i>P</wharfside_i><qc_r
ate_q>24.4</qc_rate_q><qc_intensity_q>2.9</qc_intensity_q><location_from_c>P21</location_from_c><location_to_c>P21</location_t
o_c><berth_pilot_i>true</berth_pilot_i><unberth_pilot_i>true</unberth_pilot_i><delay_c> </delay_c><status_c> </status_c><btr_d
t>2005-12-13T13:00:00.000+08:00</btr_dt><priority_c>C7</priority_c><scheme_qualify_i>X</scheme_qualify_i><section_n>-1</sectio
n_n></record>
2005-12-05 10:53:17,641 [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>