Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

hkg_qlik
Contributor II

Trim

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

1 Solution

Accepted Solutions
nagaiank
Valued Contributor III

Re: Trim

Then you should try using

PurgeChar(MEM_ID,'{}') as MEM_ID

in your load script.

4 Replies
nagaiank
Valued Contributor III

Re: Trim

You may also use

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

hkg_qlik
Contributor II

Re: Trim

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
Contributor II

Re: Trim

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
Valued Contributor III

Re: Trim

Then you should try using

PurgeChar(MEM_ID,'{}') as MEM_ID

in your load script.

Community Browser