Help with Trimming data

[Deano478]

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.

[DataNath · Accepted solution]

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

[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 · Accepted solution]

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:

[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😀