Parsing Results with spaces

[jaydiare]

I have this output from a field, with a lot of blank spaces,  what would it be the best way to convert this data into a table? or maybe a regex to parse it out better

Start

TREATMENTING ROUTES. TREATMENTS IS: GNCT

1 T12023

2 LKOUTWDF

POSITIONS ROUTES. POSITIONS IS: TOPS

1 CGHBRAB21053TBX

N S3T55NS

End.

[jaydiare]

[ITWhisperer]

From this event, what would you like to see in the table?

[jaydiare]

no spaces from the top or the bottom 

[ITWhisperer]

| rex mode=sed "s/(?ms)^\s+$\n?//g"

[jaydiare]

Start and End are not part of the output  🙂

[ITWhisperer]

What about how the table should look and other (sample) events?

[ITWhisperer]

I assume this field is from one event? Does it include the "Start" and "End."? What would you like to see in the table? Can you share other events or are they all like this i.e. same number of lines, same headings, etc.?