FILTER VALUES THAT CONTAINS LETTER CHARACTERS

[dunkindonut7777]

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?

[binuacs]

@dunkindonut7777 one way of doing this with the StartsWith function

[binuacs · Accepted solution]

@dunkindonut7777 another way of doing this with the Regex_Match function

[dunkindonut7777]

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?

[binuacs]

@dunkindonut7777 this can be achieved b using the Regex_Match filter