Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Exclude Customers when they only have an initial for a first name

Tessa
8 - Asteroid

Hi there - I think the subject line pretty much sums it up! 

 

I have a database of customers who have only a single initial for their first name. I'd like to exclude these folks, but I am not sure how to make that happen. 

 

So, if the customer's name is A Johnson, I want to exclude them.

If the customer's name is Ben Johnson, he's included. 

 

Thoughts? 

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

Hi @Tessa I mocked up a workflow let me know what you think?

T_Willins
14 - Magnetar
14 - Magnetar

Hi @Tessa,

 

Try this in the Filter tool (where names are in field "Name"

 

REGEX_Match([Name], "\w\w+?\s.*")

 

If this works, please mark this as an accepted solution to inform the Community your question has been answered!

Tessa
8 - Asteroid

Thank you- your solution worked perfectly! 

Labels