Trim

[hkg_qlik]

Hi,

I have an ID in a QVD file which looks like {9038585065}.

I want to remove the { } from all the ID's I have in the QVD File while loading.

Regards,

H

[nagaiank]

You may also use

PurgrChar('{9038585065}','{}')

[hkg_qlik]

The field name is MEM_ID. So I want to remove { }  while loading from around 50,000 records and not just for one ID.

Thanks,

H

[derekjones]

Not as efficient as krishnamoorthy's answer, but another way is as follows if it helps..

  subfield(mid(MEM_ID,2,100),'}',1) as MEM_ID_Clean

(I assume that there will be no more than 100 characters and the { will always be the first character?):

Derek

[nagaiank · Accepted solution]

Then you should try using

PurgeChar(MEM_ID,'{}') as MEM_ID

in your load script.