String Manipulation Reverse / InStrRev

[Nisusmage]

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.

[DS_SUPPORT]

Try

Code: Select all

Field(InputCol," ",Dcount(InputCol," "))

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

[datisaq]

You can do by this way also:

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

[Nisusmage]

Thank You Very Much.

[Nisusmage]

Thank You Very Much.