Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
didierodayo
Partner - Creator III
Partner - Creator III

return specific values

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Try this?

LOAD KeepChar(values,'/0123456789') as values Inline [

values

abcde1/2/3

adb2/4/5

abcdefg0/1

];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

Try this?

LOAD KeepChar(values,'/0123456789') as values Inline [

values

abcde1/2/3

adb2/4/5

abcdefg0/1

];

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
didierodayo
Partner - Creator III
Partner - Creator III
Author

Perfect Anil that will work. Thanks