Text file with multiple XML Code Blocks

Gunner49 — Fri, 08 Jan 2021 13:45:51 GMT

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

topic Text file with multiple XML Code Blocks in Talend Studio