Hello! Has anyone know how to remove the html/css ...
# suitescript
j
Hello! Has anyone know how to remove the html/css codes in a message saved search when exported to CSV/Excel? I tried using formula
REGEXP_REPLACE({message},'<[^<>]*>','')
but this doesn't completely remove all the html/css codes in a message. TIA
d
Not sure about css, but this pattern might catch your html better (captures attributes)
<\/?[\w\s\/"=]*>
Example: https://regex101.com/r/D9QejE/2
on a side note, I always find it funny when a regex pattern ends up with a smiley face in it