Deleting Middle Names

So i am trying to do a join function but one set of data has middle names, while the other doesn't. What i am trying to do is delete the middle names from my smaller set of data so i can join it properly. How would i achieve this? I am guessing the RegEx tool?

Thanks!

Accepted answers

ggruccio

Hi @krishnagandhi,

If that is the format of your data you could use the "Text to Columns" tool to parse it into three columns using the comma as the delimiter, then re-combine the columns with the first and last name only using a Formula tool.

May be a few more steps than using Regex, but should be effective.

All comments

Blake

Hi @krishnagandhi - it is hard to know exactly what you want without some sample data beyond a screenshot, but try out the attached regex tools and see if on works for you. You could also use a text to columns tool + a formula to concatenate the name if you aren't comfortable with Regex and your delimiter is always a comma. Do all you records contain this extra middle name or just some?

first,last.yxmd

ggruccio

Hi @krishnagandhi,

May be a few more steps than using Regex, but should be effective.

AbhilashR

Hi! You could do it using Regex Tool, or a simple text-to-column as well. Attached is an implementation using text-to-column as a sample.

sample.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703