RegEx "&#160"

[Neffri]

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?

[drew9]

Hi @Neffri ,

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

Hope this helps.