Parse using specific keywords in a text string

[NeilFisk]

I have a PDF file I am bringing into Designer that I can get as a text string but once in Designer, I want to parse it out based on headers that are contained within the text.  I have tried using a find and replace for the headers, but since the text file contains many characters, I'm never sure if I have selected a unique character.  I have attempted to do this with RegEx Parsing, but I don't know how to set it up.  Attached is an example in Excel with an Input tab and a desired Output tab.

Thanks!,

Neil

[NeilFisk]

I think I answered my own question.  The image below allowed me to parse with RegEx.

[Robin_McIntosh]

Have you tried this?

[Robin_McIntosh]

Just saw where you figured it out.  Wasn't sure if the order or text after each number would be the same.  But you got it.

[NeilFisk]

Thanks Robin.  I'm learning RegEx.

[Emmanuel_G]

Hi @NeilFisk ,

Interesting case...

You will find a way to do it in the attachment.

Note that this solution works even if you don't necessarily have summary, questions and thanks but it is enough that you have the same order, that is to say 1. title; 2.title, 3.title and so on. 

So even if you have 10 or 100 IDs, it will create the 10 or 100 columns with their contents.