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_