check for apostrophe

Business Central/NAV Developers Forum
1

C/AL in Navision- I’m trying to check for an apostrophe in a string. If I check for @, i’d put it in single quotes like ‘@’. Putting the apostrophe in single quotes doesn’t work (it would look like ‘’’ ). Any help would be appreciated, thanks

2

Look up the ASCII table and determine which number represents a single quotation mark.

Create a Character variable and assign it a value equal to that number.

Use FORMAT(CharVariable) to get a string representation of it and use in functions like DELCHR or your own custom function.

3

Thanks Matt, that worked fine.

4

What about ‘’’’? (4 single quotes)