Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This should work for you
Mid(FieldName, FindOneOf(FieldName,'123456789'))
HI
Try like this
Load Num(KeepChar(Test,'1234567890')) AS Test;
Load * Inline
[
Test
B0011111
B0111222
B010110
];
try mid('fieldname',1)
or 2
This should work for you
Mid(FieldName, FindOneOf(FieldName,'123456789'))
Thanks it's works. 😃