FILTER VALUES THAT CONTAINS LETTER CHARACTERS

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?

Adobe

Accepted answers

binu_acs

@dunkindonut7777 another way of doing this with the Regex_Match function

Filter_01_06.yxmd

All comments

binu_acs

@dunkindonut7777 one way of doing this with the StartsWith function

Filter_01_06.yxmd

binu_acs

@dunkindonut7777 another way of doing this with the Regex_Match function

Filter_01_06.yxmd

dunkindonut7777

Hi @binu_acs 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?

binu_acs

@dunkindonut7777 this can be achieved b using the Regex_Match filter

Filter_01_06.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335