topic quotation in conditional name - script in QlikView

quotation in conditional name - script

arsenal1983 — Mon, 07 May 2018 13:45:02 GMT

Hi,

I need to import the data set with condition:

where

[Rating Description])= 'MOODY'S LONG-TERM ISSUER RATING'

I get an error because of the quotation mark in MOODY'S

How I can handle with this?

Luke

Anil_Babu_Samineni — Mon, 07 May 2018 13:48:19 GMT

May be this?

where [Rating Description]= 'MOODY''S LONG-TERM ISSUER RATING'

sunny_talwar — Mon, 07 May 2018 13:51:46 GMT

Or this

Where WildMatch([Rating Description], 'MOODY*S LONG-TERM ISSUER RATING'

Where WildMatch([Rating Description], 'MOODY?S LONG-TERM ISSUER RATING'

Miguel_Angel_Baeyens — Mon, 07 May 2018 13:53:05 GMT

I usually replace these values during the load for a character or string I know for sure this field, say

...

Replace([Rating Description], Chr(39), '$$$') AS [Rating Description],

...

So now instead of ' you will have $$$, which is easier to find, replace, and even remove in a later step in the script prior to displaying data.

Other options:

'MOODY''S LONG-TERM ISSUER RATING' // see the double single quote to "escape" the ' character

'MOODY' & Chr(39) & 'S LONG-TERM ISSUER RATING' // use the ASCII Chr() function

sasiparupudi1 — Mon, 07 May 2018 14:09:46 GMT

where

[Rating Description])=

'MOODY'&chr(39)&'S LONG-TERM ISSUER RATING'