More Regex for parsing names! Hooray!

I have a love-hate with RegEx. I acknowledge the power it has, but can't seem to crack this particular task. I am given a variety of formats for names and need to parse out and rejoin first and last only.

Here's my expression: ^(\w+)\W?((?<=\W).+(?=\W))?\W?(\w+)?$
The only things I can't figure out are hyphenated last names and apostrophes.

Here's my data: The "Full Name" column is my input and the rest are the output of my RegEx parse.

edit: My "Data" is just filler in a variety of first and last names. The actual names are all over the place and my company wouldn't allow be to share that data. I created 9 variations that I've seen in the actual data.

Full Name	First Name	Middle Name	Last Name
First Last	First		Last
First Middle Last	First	Middle	Last
First Last-Last	First	Last	Last
First O'Last	First	O	Last
First Middle Middle Last	First	Middle Middle	Last
First Middle Last-Last	First	Middle Last	Last
First O'last-Last	First	O'last	Last
First Middle O'Last	First	Middle O	Last
First M Last	First	M	Last

I know that the answer is likely in one of the hundred posts on this topic, but I just can't find it! Is anyone able to help?

Thanks!

RegEx Name Parse.yxmd

Regex

Accepted answers

MarqueeCrew

@JFurda ,

I'm not going to give you a full-answer. Instead, please consider creating a FILTER to have apostrophe (hint: contains()) data going to separate logic.

after you separate apostrophe stuff, you can do things with normal string functions.

CountWords() = 3 gets handled as GetWord(0) and GetWord(2)

cheers,

Mark

All comments

MarqueeCrew

@JFurda ,

I'm not going to give you a full-answer. Instead, please consider creating a FILTER to have apostrophe (hint: contains()) data going to separate logic.

after you separate apostrophe stuff, you can do things with normal string functions.

CountWords() = 3 gets handled as GetWord(0) and GetWord(2)

cheers,

Mark

atcodedog05

Hi @JFurda

Infact i couldn't figure out the regex pretty quick but there is a quick solution using formula tool.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

RegEx Name Parse.yxmd

atcodedog05

Hi @JFurda

Hooray found the regex

(\w+) (.*[\s\-'])(\w+)

Regex Tool config:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

RegEx Name Parse.yxmd

JFurda

Ah, I should have been clearer. My "Data" is just filler in a variety of first and last names. The actual names are all over the place and my company wouldn't allow be to share that data. I created 9 variations that I've seen in the actual data. Thanks, though!

JFurda

Hmm. So perhaps I could get the "words" assigned out. The first one will be the first name. I could sort descending and pull that as the last name.

I'll give that a go! Thanks!

atcodedog05

Hi @JFurda

Thank you for the consideration and detailed issue report.

I will look into it. If am able to calibrate an output I will reply back on this post.

mceleavey

Hi @JFurda ,

I've attached my solution. This should give you what you want.

I've also attached my Grouped RecordID tool which I used in the solution.

Let me know if this fixes the issue.

You're a lifesaver! I built a simple flow that omits the need for RegEx. I can also add in other considerations for salutation, attribution, etc. with additional formulas.

I had to make the Word Count variable an Integer, but the rest was simple!

RegEx Name Parse.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703