Text with single quotes not being returned

[xbric]

Hi,

I use Field Updater a lot in my forms and I usually only need to retrieve a single number or a single word from a text field.

Recently, I tried to retrieve the content of a text field with some complete French sentences into it. I noticed that if that text field contains the character ' (single quote), the field content will not be returned.

The single quote is very common in the French language (l'école, l'amour, l'étoile, etc.) and I have no control over what the user will put into the field I need to retrieve.

Is there a work around for that situation ? Are there other characters that should not be used in text fields ?

Regards,
Claude

[ihslimn]

Cannot reproduce the issue. Can you give some concrete steps?

[xbric]

Hi Ihslimn,

Sorry for the delay.

On my side, I've created a CCT and a form to fill it. In any text field, I can put texts like L'école est fermée aujourd'hui (which means the school is closed today). I can see in the CCT record the field is filled with that same content with the 2 single quotes : L'école est fermée aujourd'hui

When I try to retrieve the content of that text field through Field Updater, it appears blank unless I remove the 2 single quotes.

Maybe the problem comes from the ascii code my French keyboard use for the single quote. If you can't reproduce the problem by copying my French text above, I'll try to see what code is used for the '. My guess is that this same ' is also used somewhere else as a delimiter.

Regards,
Claude

[xbric]

Oh .... I forgot to mention: The problem also arise when I use just 1 single quote like in the sentence L'école est ouverte.