Update

[JD Kromkowski]

How do I do an update when I want to put a single quote ‘ in the text.

E.g.

change:

Workers” Compensation Commission

to

Workers’ Compensation Commission

I can obviously by hand under enter text into a single record using single quote, but parser associated with the Update is temperamental. I can’t figure it out.

Is the parser being used just not sophisticated enough. I think I could do this in a program. ‘Workers’||.char(39)

[JD Kromkowski]

epiphany just now.

= ‘Workers’||’&#39 ‘||’Compensation Commission’

But alas wrong, too also no love for &apos either.
Haven’t tried these, but there must be a solution (with programmatically doing it outside of Personal) if not it seems like a bug to me.

? ’
? {U209}

[JD Kromkowski]

I thought I some something. where you see ? ‘ I had typed ” & r s q u o ;” no spaces

• This reply was modified 7 years, 3 months ago by JD Kromkowski.
• This reply was modified 7 years, 3 months ago by JD Kromkowski.
• This reply was modified 7 years, 3 months ago by JD Kromkowski.

[Michael]

Hi John,

It is actually easier than you thought. Just put two apostrophes instead of 1:
= ‘Worker”s Compensation Commission’

[JD Kromkowski]

That was my first instinct – SORT OF.

Ah, you must use TWO single quotes not a double quote.

Maybe add this to the documentation.

[Author]

Posts