Remove all special characters/punctuations except for - and &

[Idyllic_Data_Geek]

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!

[atcodedog05]

Hi @Idyllic_Data_Geek 

Try this formula

Hope this helps : )

[binuacs · Accepted solution]

@Idyllic_Data_Geek 

REGEX_REPLACE([Text],'[^\w\s\-&]','')

[Idyllic_Data_Geek]

The issue with this one is that it also truncating the valid spaces in between

[atcodedog05 · Accepted solution]

Hi @Idyllic_Data_Geek 

Please find the updated formula

Hope this helps : )

[Idyllic_Data_Geek]

Hello.

 DO you know what this formula is doing? IIF(isNull([Row-1:1]),1,[Row-1:New Column]+1)

[ddiesel]

Hi @Idyllic_Data_Geek!

It looks like the formula you are referencing is in a Multi-Row formula tool.

Translation:

If column "1" is null in the row above the current row, then the value of 1 is returned. Otherwise, "New Column" plus 1 from the row above the current row is returned. 

Sounds like the new column is creating a RecordID. Is it working for you? Looks odd to me.

If you need help with this formula, I recommend opening a new topic.

[martinson]

Attempt 1