Parse an Excel field

[George_Fischetti]

Hi Folks - I was presented with this information this morning which is a file that contains website submissions that have been collected within a single excel field.  I've tried parsing with XML but this is not a true XML file given there is no end of line indicator.   Each line that starts with </br> should be its own field where the information after the </br>  is the field name and the text after the colon is the field contents.

I'm not well versed in Regex but will try that now, but I could use some guidance as this is something I've never done with Alteryx.

The information on the top line (Site:) is consistent throughout and can be removed.

Thank you!!

[atcodedog05]

Hi @George_Fischetti 

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[George_Fischetti]

@atcodedog05 Thanks in advance for the help.  I'm attaching a sample.  There could be more fields that what I show here based on what information the website collected.  The main idea is that all fields are noted by the </br>.  If there are extra fields that result I can ignore those or not import them.

Hopefully this is enough information for you.  Appreciate the chance to learn a new application of these tools.  This product is amazing.

[atcodedog05 · Accepted solution]

Hi @George_Fischetti 

Here is how you can do it.

Workflow:

Hope this helps : )

[George_Fischetti]

@atcodedog05 This is brilliant, adapted to the main data file seamlessly with a few tweaks.  Thanks for the learning opportunity!!!

[atcodedog05]

Happy to help : ) @George_Fischetti 

Cheers and have a nice day!