Hello,
I am trying to do a function to remove and replace some special characters from a text field using formula DataType, However, how can I remove the apostrophes (')
Here is the formula (Last one with apostrophe)
CASE
WHEN Charindex('!',[@field:TITLE],0) <> 0 THEN Replace([@field:TITLE], '!', '')
WHEN Charindex('#',[@field:TITLE],0) <> 0 THEN Replace([@field:TITLE], '#', '')
WHEN Charindex(':',[@field:TITLE],0) <> 0 THEN Replace([@field:TITLE], ':', '')
WHEN Charindex(''',[@field:TITLE],0) <> 0 THEN Replace([@field:TITLE], ''', '')
END