Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
Di
Solved! Go to Solution.
Hi @dbhamber
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 <b></b> tag and answer is surrounded by <p></p>
Hope this helps 🙂
Hi @dbhamber,
I would use two Regex tools to extract the pieces of information:
First regex tool allows us to parse out everything between <b> 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
Di
Hi @dbhamber
Sorry for leaving out font size column 😅. I have update my workflow to capture it.
<b>(.*)</b>.*<p.*font-size: (.*)">(.*)</p>
Workflow:
Hope this helps 🙂
