Filter Special Characters

Hi All,

I wanted to filter the records which has only special character * I used the custom filter -

REGEX_Match([column name],"^\s?[a-zA-Z][a-zA-Z.\s]*$")

And got the following result but the problem is I am getting records with special character ' as well.

Can anyone please suggest how to get rid of them.

Justify *
American Pharoah *
I'll Have Another
Sunny's Halo
Affirmed *
Seattle Slew *
Secretariat *
Citation *
Assault *
Count Fleet *
Whirlaway *
War Admiral *
Omaha *
Gallant Fox *
Sir Barton *

Thanks,

Kaveri Jaiswal

Data Investigation

Accepted answers

fmvizcaino

Hi @kaverijaiswal ,

I'm attaching a solution where I show how to do it with the filter tool and the contains formula or regex_match formula.

Contains([Field1], '*')

REGEX_Match([Field1], '.*\*$')

LEt me know if this works for you.

Best,

Fernando Vizcaino

2020-04-03 Filter Special Characters.yxmd

All comments

fmvizcaino

Hi @kaverijaiswal ,

I'm attaching a solution where I show how to do it with the filter tool and the contains formula or regex_match formula.

Contains([Field1], '*')

REGEX_Match([Field1], '.*\*$')

LEt me know if this works for you.

Best,

Fernando Vizcaino

2020-04-03 Filter Special Characters.yxmd

grossal

Hi @kaverijaiswal,

I think the dot in the second part might be the issue. You could also simplify it. Please try this one:

REGEX_Match([Names],"^\s?[a-zA-Z\s?]+$")

Let me know if it works.

Best

Alex

kaverijaiswal

Hi @fmvizcaino,

Your solution worked for me. Thanks.

Can you please help me understanding why my filter formula did not work? Where I was going wrong so that I can keep that in mind for next exercises.

Thanks,

Kaveri Jaiswal

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703