Data Parsing to Rows

[AshrafHaris]

Hi All,

Can anyone help me to parse this 1 row data to multiple rows according to the number given

Thank You!

[caltang]

That looks like XML. Please provide relevant data to this use case, and kindly provide your criteria in as much detail as possible. If you have a workflow built halfway, kindly export that over as well.

[AshrafHaris]

Hi Caltang, the data was downloaded originally in an excel format. Which turns out in XML. There were no workflows involve, so here I attach along with the dataset only.

[caltang]

Your image is that of a Results pane... from a workflow... 

The data you provided doesn't have the columns you have - but I'll assume you only need rows from one example? You can pretty much duplicate the rest on your own thereafter.

Is that all you require?

[caltang · Accepted solution]

Here's a sample. PFA.

[flying008 · Accepted solution]

Hi, @AshrafHaris 

FYI. Tokenize by :

<p>(.+?)<\/p>

[AshrafHaris]

Yes Caltang this is what I wanted. I will replicate this and apply to all rows that have the XML format ! Thank You so much for the help 😊

[AshrafHaris]

This is cool, I have not thought of using Regex as a way to parse the rows. Thank you so much ! 😍