Remove head and tail for xml

jamespb · February 21, 2019, 6:04am

I am trying to break one xml file into multiple event.
I use <PMSetup as pattern to splite
pattern => "<PMSetup"
How can I remove the beginning 2 lines (<?xml version="1.0"?>) and the last line?

or, how can I use multiple to splite message between <PMSetup and

<?xml version="1.0"?> ...............................................................

Badger · February 21, 2019, 2:28pm

What does the data look like?

jamespb · February 22, 2019, 9:02am

<?xml version="1.0"?>

jamespb · February 22, 2019, 9:04am

2019-02-22_170353

jamespb · February 22, 2019, 9:05am

I find discuss always remove my xml post
thanks

Badger · February 22, 2019, 1:27pm

It is interpreting the XML as HTML. You can either precede and follow the XML with lines containing three backticks (```) or else in the edit pane, select the XML and then click on </> in the toolbar above the pane, which will blockquote it.

Are you consuming the entire file as a single event?

jamespb · February 25, 2019, 5:29am

I think splite by PMSetup is better, because each PMSetup would have 1000+ field

jamespb · March 4, 2019, 3:19am

I choose to use python to phase and fixed this issue. thanks for helping

system · April 1, 2019, 3:24am

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.