Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Then you should try using
PurgeChar(MEM_ID,'{}') as MEM_ID
in your load script.
You may also use
PurgrChar('{9038585065}','{}')
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
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
Then you should try using
PurgeChar(MEM_ID,'{}') as MEM_ID
in your load script.