Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert HTML to Excel cell formating

markashman
8 - Asteroid

Hi, I have an API download that includes text fields that contain standard html, so <p> for new lines & <li> for bullet lists.

 

I want to maintain this when loading into excel, so need to convert it to something excel understands so my output in an excel looks something like:

 

We need these items:

  • A Box
  • A Table
  • A Chair

Thanks

 

Anyone have a method for doing this?

2 REPLIES 2
AndrewDMerrill
13 - Pulsar

Without sample input, its difficult to provide exact info. I didn't use precise HTML formatting, but this workflow should point you in the right direction:

Screenshot.png

 

Happy Solving!

markashman
8 - Asteroid

Thanks, useful - there are so may variants of tags in the same return, so <li> & <li style.. etc I ended up having to use multiple nested REGEX_replace in multiple formula tools, but got there in the end.

Labels