Trying to wrangle REGEXP_REPLACE in a saved search...
# suiteanalytics
d
Trying to wrangle REGEXP_REPLACE in a saved search. I'm wanting to replace all characters outside of the ASCII range (> U+007E) with their decimal unicode number (i.e. © → 0169) The formula(text) I'm trying to use is REGEXP_REPLACE({displayname},'([^ -~])',ASCII('\1')) This doesn't work; instead of giving me the ASCII of the first match (the \1 part), it gives me the ASCII number for the back-slash (1st char in literal string '\1') Any solutions? _P.S. feeding only '\1' as the 3rd param of REGEXP_REPLACE correctly returns all matches for '([^ -~])' pattern_