Apostrophe in Data

[oscargoldman]

We have data that has apostrophes in it (Men's, Women's, Kid's) and we are trying to use these data fields in formulas but the apostrophe is causing issues.  How do we handle this.  The example of the formula is: 

CASE

WHEN [@field:Gender] = 'MEN'S' THEN 1

END

[Mathilda]

8 hours ago, oscargoldman said:

We have data that has apostrophes in it (Men's, Women's, Kid's) and we are trying to use these data fields in formulas but the apostrophe is causing issues.  How do we handle this.  The example of the formula is: 

CASE

WHEN [@field:Gender] = 'MEN'S' THEN 1

END

You need to  double-up the single quote character:

CASE

WHEN [@field:Gender] = 'MEN''S' THEN 1

END

 

[oscargoldman]

perfect - thanks...

[NailDyanC]

Hi just to add to the previous answer above, you may also consider using this workaround:

CASE

WHEN [@field:Gender] = 'Men' + (char(39)) +'s'
THEN '1'
ELSE '0'

END

 

You may use 'char(39)' as an alternative for that symbol.

[autonumber]

Hello! I just want to share this article that  shows the full list of functions, operators and expressions that are used in report DataPages and for the tables design.

https://howto.caspio.com/function-reference/

 

[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')