topic Subfield of multiple delimiter in App Development

Subfield of multiple delimiter

Anonymous — Thu, 17 May 2018 02:01:55 GMT

Hello communities of Qlik,

I have a script where i want to split a string to 3 parts Length Width Height. Due to possibly human error, there's a record of 'XX' instead of 'X'. With below script, I am able to remove 'X' but not 'XX' as shown in the bottom image which shows nothing. How should i approach this problem?

Re: Subfield of multiple delimiter

sunny_talwar — Thu, 17 May 2018 02:12:07 GMT

May be try this

KeepChar(SubField(Replace(PM_DIMENSION, 'XX', 'X'), 'X', 1), '0123456789.') as LENGTH,

KeepChar(SubField(Replace(PM_DIMENSION, 'XX', 'X'), 'X', 2), '0123456789.') as WIDTH,

KeepChar(SubField(Replace(PM_DIMENSION, 'XX', 'X'), 'X', 3), '0123456789.') as HEIGHT