Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vasiliy_beshent
Contributor III

Ho to use right delimiter?

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?

1 Solution

Accepted Solutions

Re: Ho to use right delimiter?

May be try this:

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

3 Replies

Re: Ho to use right delimiter?

May be try this:

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

vasiliy_beshent
Contributor III

Re: Ho to use right delimiter?

Thx a lot!

Re: Ho to use right delimiter?

No problem