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

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?

Data Investigation

Accepted answers

JosephSerpis

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

Name_131119.yxmd

All comments

JosephSerpis

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

Name_131119.yxmd

T_Willins

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

Thank you- your solution worked perfectly!

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335