DSXchange

Hello,

I have a requirement to extract a Surname from a name field. The issue is when the user has multiple second names.

How would I extract the last "field" from the string?

example:

'Joe Blogs'[' ',2,1] = 'Blogs'
'Jenny Marge Ashby'[' ',2,1] = 'Marge' *here is should be Ashby

Thanks.

Try
Change the " " (Space) to your desired delimeter.

You can do by this way also:

Field_name[Index(Field_name," ", Count(Field_name," "))+1,len(Field_name)]

Thank You Very Much.

Thank You Very Much.