Subfield of multiple delimiter

[Anonymous]

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?

[sunny_talwar · Accepted solution]

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