Set specific row / field value in a table

[krissy_s]

Hello

I am trying to set a specific row / field value in my table.

The problem is the specific value has a ' in the field name.

The following will work, no problem: =if(Match(Risktype,'Liability - Professional Indemnity'),RiskType)

But the following will not work: =if(Match(Risktype,'Liability - Professional Indemnity Lloyd's'),RiskType),

an error message is displayed as the name of the field has an apostrophe, in the "Lloyd's" word. As this is a set value in the list I cannot simply remove the apostrophe.

Does anyone have any suggestions please how to deal with the apostrophe please?

Many thanks 🙂

[sunny_talwar]

Have you tried this with the Escape sequences (two single quotes)

=if(Match(Risktype,'Liability - Professional Indemnity Lloyd''s'), RiskType)

[krissy_s]

Yay!! It worked! (I didn't know about Escape Sequences).

Thank you so much! 🙂

[sunny_talwar · Accepted solution]

Awesome, please close the thread by marking the correct response.

Best,

Sunny