Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SubString value

Hi,

Please find the scenario below.

There is a field contains the following values

B0011111

B0111222

B0101101

I need the output as below.

11111

111222

101101

Any one can help on this?

1 Solution

Accepted Solutions
jfkinspari
Partner - Specialist
Partner - Specialist

This should work for you

Mid(FieldName, FindOneOf(FieldName,'123456789'))

View solution in original post

4 Replies
MayilVahanan

HI

Try like this

Load  Num(KeepChar(Test,'1234567890')) AS Test;

Load * Inline

[

Test

B0011111

B0111222

B010110

];

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

try mid('fieldname',1)

or 2

jfkinspari
Partner - Specialist
Partner - Specialist

This should work for you

Mid(FieldName, FindOneOf(FieldName,'123456789'))

Not applicable
Author

Thanks it's works. 😃