We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

RegEx "&#160"

Neffri
8 - Asteroid

Hello,
I take the results from SharePoint. 
I've cleaned the HTML tags using RegEx but still I have a problem with '&#160' sign.

Example:

'Lorem Ipsum,  Lorem Ipsum  Lorem Ipsum'
Do you know how I can remove it from the text?

1 REPLY 1
drew9
8 - Asteroid

Hi @Neffri ,

 

If this same value is occurring in your text you can simply use REPLACE([HTMLTags], '&#160', '')

 

Hope this helps.

Labels