Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Anyone with an easy way to return the following specific values from the list below?
values:
abcde1/2/3
adb2/4/5
abcdefg0/1
expected result
1/2/3
2/4/5
0/1
In short I just want to purge all alphabets and keep the rest including the slashes.
Thanks
Try this?
LOAD KeepChar(values,'/0123456789') as values Inline [
values
abcde1/2/3
adb2/4/5
abcdefg0/1
];
Try this?
LOAD KeepChar(values,'/0123456789') as values Inline [
values
abcde1/2/3
adb2/4/5
abcdefg0/1
];
Perfect Anil that will work. Thanks