apostrophe Cell's Text with Apostrophes

[Esraaa]

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 

[Mathilda]

13 hours ago, Esraaa said:

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 

Hi Esraa,

Try using the following syntax:

WHEN Charindex('''',[@field:TITLE], 0) <> 0 THEN Replace([@field:TITLE], '''',' ') 

Hope that helps

[Esraaa]

Thank you dear. It worked! 

[NailDyanC]

Hi, just to add in the previous comment above if you would like to remove apostrophes (') or use it in your formula, you may use 'char(39)' as an alternative for that symbol. Like for example:

CHARINDEX(char(39),[@field:Fieldname])). 

[Kurumi]

You may also check Caspio's online article: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/remove-special-characters-for-input-fields/

[Kurumi]

Hi! Just wanted to share this solution if you want to read or accept the single quote or apostrophe (') in the formula: https://stackoverflow.com/questions/9596652/how-to-escape-apostrophe-a-single-quote-in-mysql

Example:

Replace([@field:FIELDNAME], 'Can''t found the name', 'Remove name')