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 should be its own field where the information after the 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!! ExcelFieldParse.png

Parse an Excel field

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!!

ExcelFieldParse.png

Parse

Accepted answers

atcodedog05

Hi @George_Fischetti

Here is how you can do it.

Workflow:

Hope this helps : )

template.yxmd

All comments

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.

ExampleForAlteryxSupport.xlsx

atcodedog05

Hi @George_Fischetti

Here is how you can do it.

Workflow:

Hope this helps : )

template.yxmd

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!

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335