Hi I have a data here in which there is a column that contains numeric and alphanumeric characters. I want to retain those values that contains only numbers and filter out those values that contains letters. Data: Code1222 100ABCD00311323 200XYZ900901323 200IDEY8001222 100 Expected Output1222 1001323 2001323 2001222 100 I want to know how this would work using regex formula in a filter tool. Can you help me with this one pls?

FILTER OUT VALUES THAT CONTAINS LETTER AND ANY SPECIAL CHARACTERS

Hi I have a data here in which there is a column that contains numeric and alphanumeric characters. I want to retain those values that contains only numbers and filter out those values that contains letters.

Data:

Code
1222 100
ABCD0031
1323 200
XYZ90090
1323 200
IDEY800
1222 100

Expected Output

1222 100

1323 200

1222 100

I want to know how this would work using regex formula in a filter tool. Can you help me with this one pls?

Adobe

Accepted answers

Qiu

@dunkindonut7777

We can use the RegMatch funtion for only records that match the combination with numbers and space.

0908-dunkindonut7777.yxmd

All comments

Qiu

@dunkindonut7777

We can use the RegMatch funtion for only records that match the combination with numbers and space.

0908-dunkindonut7777.yxmd

dunkindonut7777

Hi thank you for this. How about this one. I want to remove the values that only contains letters and retain the alphanumeric and numeric characters only.