topic Re: How to manage Apostrophe in String in QlikView

How to manage Apostrophe in String

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following statement that throws an error. It's the apostophere in my match condition. I read some articles relatting to escape sequences from a previous question but I'm still having trouble. Can someone help with the syntax. I have tried using brackets instead of single quotes and tried other examples too.

TestTable:

LOAD

PKID,

REASON,

PROGRAM

FROM MAINTABLE

WHERE PROGRAM = 'CLOSED'

AND MATCH(REASON, 'Don't need')

Re: How to manage Apostrophe in String

sunny_talwar — Wed, 15 Jun 2016 18:40:49 GMT

Try this:

TestTable:

LOAD

PKID,

REASON,

PROGRAM

FROM MAINTABLE

WHERE PROGRAM = 'CLOSED'

AND MATCH(REASON, 'Don''t need')

Note: the two single quotes '' (not a double quote)

Re: How to manage Apostrophe in String

swuehl — Wed, 15 Jun 2016 19:18:48 GMT

Well, that's what has been already suggested in the other thread , so I think it is not working for mrjohn123, right?

Though, seems to work for me:

Text:

LOAD *

WHERE Match(Reason,'Don''t need');

LOAD recno() as ID, * INLINE [

Reason

Don't need

Why not?

];

What error message do you get, mrjohn123?

Re: How to manage Apostrophe in String

Anonymous — Wed, 15 Jun 2016 20:04:19 GMT

I was able to FINALLY resolve my issue. Once I identfied escape sequences and to use single quotes and not double quotes. I was also receiveing a "Grabage" In statment error that I resolved but closing the app out and logging back in. Thank you all for your help as I'm currently creating my 2nd app.

Re: How to manage Apostrophe in String

Anonymous — Wed, 15 Jun 2016 20:04:45 GMT

I was using a double quote, thanks for the call out.