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 NameKen7Ken@KenKenPalliserPalliserPalliser!PalliserDonaldPeterMadeleineJanePerry^SteveSteveRaymond_ChristianDoris&HanaAngela*AngelaElenaJosephJosephJosephJoseph%JackJackJackJaniceEdith$FranklinArleneSumnerSharonRobert1Robert

Filter rows with numbers or special characters

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

Palliser

Palliser!

Palliser

Donald

Peter

Madeleine

Jane

Perry^

Steve

Raymond_

Christian

Doris&

Hana

Angela*

Angela

Elena

Joseph

Joseph%

Jack

Janice

Edith$

Franklin

Arlene

Sumner

Sharon

Robert1

Robert

Parse

Accepted answers

Thableaus

@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

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

All comments

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

Filtering out numbers and special character solution.yxmd

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.

Present_guy

That is so clever! Thanks for sharing this!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335