Currently I'm using data cleansing tool to remove the punctuations from a field. however the requirement is to remove everything except for hyphen – and the ampersand & symbols. How can I accomplish this? Thanks in advance for your help!
@Idyllic_Data_Geek
REGEX_REPLACE([Text],'[^\w\s\-&]','')
Hi @Idyllic_Data_Geek
Please find the updated formula
Hope this helps : )
Try this formula
The issue with this one is that it also truncating the valid spaces in between
Attempt 1
