Hi I have a data here that contains alphanumeric and numeric alone characters, I just want to filter out those values that contains alphanumeric and alphabets, to separate the the numeric values alone.
Code |
40000 |
400001 |
400002 |
Interest4545 |
Interest |
Misc.788 |
490001 |
Expected Output |
40000 |
400001 |
400002 |
490001 |
Can you help me this one pls?
Solved! Go to Solution.
Hi @binuacs thank you for the suggested solution. I would like to ask further question, how about in an amount field that contains punctuations. I want to separate only those values that contains alphabet and alphanumeric.
Amount |
5371 |
10 |
18 |
711.67 |
PERIODICPENALTYýýApply Repaymentý |
9.17 |
PERIODICPENALTYýýAdjust324434 |
AccountýýAdjust Balances232434 |
-578.99, |
-711.67, |
Expected Output |
5371 |
10 |
18 |
711.67 |
9.17 |
-578.99, |
-711.67, |
Can you help me segregate this one pls?