Survey Data Cleaning

Hi All,

I am new to Alteryx and would appreciate any help.

I was hoping would be able to help me or point me in the right direction.

I am trying to clean some Survey data in Alteryx, I have tried, cleaning, Formula, Text to Columns even RegEx does not seem to be working for me.

I want to remove all of the syntax and just keep the highlighted in the field, some of the fields can be blank and to output into .xlsx

The data is from a SAP systems.

I have attached the file with the field, any help or guidance in preparing data from a survey,

Thanks

Macros

Accepted answers

If your usecase is solved. You can mark the helpful replies as Accept Solution. 🙂

Here is how you can do it. I am regex tool parse mode

Workflow:

Regex:

<b>(.*)</b>.*<p.*>(.*)</p>

I am using the logic that Question is surrounded by tag and answer is surrounded by

Hope this helps 🙂

I would use two Regex tools to extract the pieces of information:

First regex tool allows us to parse out everything between and it's closing tag

<b>(.*?)</b>

The second regex tool parses out the font size value and the following piece of text

<p style="font-size: (.*?)">(.*?)</p>

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

Hi Jonathan,

That was great, however my output shows only one column, do I need to make any changes to settings anywhere.

I want my output to show 3 columns just like your snapshot.

Thanks in advance