How to remove ', from my source string

[ananyaghosh]

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'

[qlikcheepirishe]

use subfield function

[Peter_Cammaert]

=mid(SourceString, 3)

[Anil_Babu_Samineni]

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

[Colin-Albert]

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

[balabhaskarqlik]

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

or

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

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