Skip to main content
Announcements
Happy New Year! Cheers to another year of collaboration, connections and success.
cancel
Showing results for 
Search instead for 
Did you mean: 
Gunner49
Contributor
Contributor

Text file with multiple XML Code Blocks

Hi All,

I have a requirement where we have a text file with multiple XML code blocks along with additional information.

Sample XML :

# ID:1238785113# REQID:AB1234BV# PRCD:SAMPLE# PRGID:268be371-5e6d

REQ 4d50e4cb ABN12349854 2021-01-08 08:01:59.398 AB ABNDERW A 51 6.1.3.230 1211 0

IO 4d50e4cb <?xml version="1.0"?><Book type="Children"><content>.......</content></Book>

# ID:98724551# REQID:BR12345# PRCD:SAMPLE# PRGID:531478-5e6d

REQ 1b241341 B23a12454 2021-01-08 08:01:59.398 AB ABNDERW A 51 6.1.3.230 1211 0

IO 1b241341 <?xml version="1.0"?><Book type="Education"><content>.......</content></Book>

...so on

We need to remove the unwanted log information and extract only the XML content marked in Bold into multiple output XML files and process them.

Can anyone suggest how to remove the unwanted information from the file and process only the XML content into multiple output files?

Thanks

Labels (3)
0 Replies