Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
use subfield function
=mid(SourceString, 3)
You can use as simple as PurgeChar(FieldName, Chr(39))
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
Use: PurgeChar(col1, Chr(39)) as Col1
or
Replace(col1, chr(39),'') as col1
or check this link: Field names auto-quoted | Qlik Community