Filter Special Characters

[kaverijaiswal]

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

[fmvizcaino · Accepted solution]

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

[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