FILTER OUT VALUES THAT CONTAINS LETTER AND ANY SPECIAL CHARACTERS

[dunkindonut7777]

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

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?

[Qiu · Accepted solution]

@dunkindonut7777 

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

[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.

Code

Property

1000

1134ML

1134ML

1124N

Real

Expected output:

Code

1000

1134ML

1134ML

1124N

Can you help me with the regex formula?

[Qiu]

@dunkindonut7777 
How about this one?