Parse using specific keywords in a text string

Question

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

Example.xlsx

Emmanuel_G · Answer

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.

Parse using specific keywords in a text string.yxmd

NeilFisk · Answer

Thanks Robin.  I'm learning RegEx.

Robin_McIntosh · Answer

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.