Filter rows with numbers or special characters

[RKSPREDDY]

Hi, I am relatively new to the Alteryx. I have a problem statement, kindly suggest me the solution.

I need to filter rows with either numbers or special characters. Below is my data. In these I need to filter out Ken7, Ken@, Palliser!, Perry^, etc.

First Name

Ken7

Ken@

Ken

Ken

Palliser

Palliser

Palliser!

Palliser

Donald

Peter

Madeleine

Jane

Perry^

Steve

Steve

Raymond_

Christian

Doris&

Hana

Angela*

Angela

Elena

Joseph

Joseph

Joseph

Joseph%

Jack

Jack

Jack

Janice

Edith$

Franklin

Arlene

Sumner

Sharon

Robert1

Robert

[Thableaus]

Hi @RKSPREDDY 

Use Filter Tool in Custom Filter mode with this RegEX formula:

REGEX_MATCH([First Name], "^[a-zA-Z]+$")

True Side will be all of your "only letters" based words

False Side will contain rows with special characters and numbers.

Cheers,

[princejindal]

Check out my solution. A quick work around :)

But I am sure there are other better ways

[RKSPREDDY]

Thanks a lot Thableaus, it's working but it is also filtering rows with dot (.) and space. For me names with dot & space are acceptable. Can you please suggest how can I keep these records out from filtering.

[princejindal]

This should solve it.

REGEX_MATCH([First Name], "^[a-zA-Z. ]+$")

Note that I have added (.) and space to the formula suggested by @Thableaus 

[Thableaus · Accepted solution]

@RKSPREDDY 

EDIT: REGEX_MATCH([First Name], "^\s?[a-zA-Z][a-zA-Z.\s]*$")

This assures that the row starts with a letter and has letters. The other formula can get rows with "...." or "    ".

@princejindal it's important to label space as "\s" character.

Cheers,

[RKSPREDDY · Accepted solution]

Thanks a lot Thableaus, it's working perfectly. Thanks @princejindal, appreciate both of your time on providing solution.

[Present_guy]

That is so clever! Thanks for sharing this!