Ho to use right delimiter?

[Vasiliy_Beshentsev]

Hello!

If i want to use comma as delimiter - it's no problem: SubField(Field1, ',' ,14) as Result15

If i want to use single quota as delimiter - like this:  SubField(Field1,'''',14) as Result15

How to write correct single quota in script?

[sunny_talwar · Accepted solution]

May be try this:

SubField(Field1, Chr(39),14) as Result15

[Vasiliy_Beshentsev]

Thx a lot!

[sunny_talwar]

No problem