+ Start a Discussion
jvolkovjvolkov 

Custom Formula That Determines If A Text Field Contain An Apostrophe

How could a custom formula be written to return true if a text field contains an apostrophe?

 

The formula CONTAINS(Title, """) returns this error, Error: Syntax error. Missing ".

 

Any way around this?

 

-Thanks

RatherGeekyRatherGeeky

Hard to see your formula since it automatically put in a smiley face. Better to include formulas and code by using the paste code function here.

 

Anyway, have you tried this?

 

 

CONTAINS(Title, "'")

 

 

 

jvolkovjvolkov
Yes but that only returns if they have the ' character, I guess I meant to say quotation mark " not Apostrophe '.
rpr2rpr2

You can surround the quote with apostrophes, and it will do what you want!

 

CONTAINS(Title, '"')

You may want to edit the title of this thread so that it is more accurate in case others are searching for this in the future.

Message Edited by rpr2 on 05-03-2009 11:38 AM