topic Re: How to remove ', from my source string in QlikView

How to remove ', from my source string

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

Hi,

How to remove ',

for the below string?

','GEO_KEY','CNTRY_ID','SC_CNTRY_ID','CNTRY_NAME','CNTRY_ISO_CODE_NUMERIC','CNTRY_ISO_CODE_2CHAR','CNTRY_ISO_CODE_3CHAR','STATE_ID','STATE_CD','STATE_NAME','REGN_ID','REGN_CD','REGN_NAME','TIME_ZONE','UPD_TS'

Re: How to remove ', from my source string

qlikcheepirishe — Mon, 26 Jun 2017 10:58:32 GMT

use subfield function

Re: How to remove ', from my source string

Peter_Cammaert — Mon, 26 Jun 2017 11:02:04 GMT

=mid(SourceString, 3)

Re: How to remove ', from my source string

Anil_Babu_Samineni — Mon, 26 Jun 2017 11:02:52 GMT

You can use as simple as PurgeChar(FieldName, Chr(39))

Re: How to remove ', from my source string

Colin-Albert — Mon, 26 Jun 2017 11:18:24 GMT

Are you looking to remove just the first 2 characters or every occurrence of ', from the string?

To remove the first two characters then use mid(String, 3)

To remove every occurrence of ', then use replace(String, chr(39)&chr(44), '')

chr(39) is ascii for a single quote

chr(44) is ascii for a comma

Re: How to remove ', from my source string

BalaBhaskar_Qlik — Mon, 26 Jun 2017 12:35:10 GMT

Use: PurgeChar(col1, Chr(39)) as Col1

Replace(col1, chr(39),'') as col1

or check this link: Field names auto-quoted | Qlik Community