Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Subfield of multiple delimiter

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?

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

1 Reply
sunny_talwar

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