Help with Trimming data

Hi folks,

Just a quick one I have the sample names:

Name

Ameila Rose Doe

James O'shaughnessy

I just need to extract the first names in this case just Amelia and James. I've tried a few differing approaches but have had 0 luck.

Any guidance will be of huge help cheers in advance.

Workflow

Help

Accepted answers

DataNath

Hey @Deano478, you should just be able to use the GetWord(). It's 0-based so just call that:

Isolate first name.yxmd

DataNath

No problem @Deano478, you could use something like this? Of course it's hard-coded so not ideal but if it's only for a small number of cases then ought to be fine:

Isolate first name.yxmd

All comments

DataNath

Hey @Deano478, you should just be able to use the GetWord(). It's 0-based so just call that:

Isolate first name.yxmd

Deano478

@DataNath Wow I have never seen this function before so it looks like I learned something new today that's super handy cheers for that.

Deano478

@DataNath sorry I have one more situation I need to ask you about if you don't mind I have a name which is: Ann Marie Lyons and I need to keep Ann Marie only in this case how could I go about doing that particular one?

DataNath

No problem @Deano478, you could use something like this? Of course it's hard-coded so not ideal but if it's only for a small number of cases then ought to be fine:

Isolate first name.yxmd

Deano478

@DataNath Cheers for that I'll give it a go and see where I get to if I do have any issues i'll be sure to let you know😀

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703