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.
String Manipulation Reverse / InStrRev
Moderators: chulett, rschirm, roy
String Manipulation Reverse / InStrRev
~The simpliest solutions are always the best~
~Trick is to understand the complexity to implement simplicity~
~Trick is to understand the complexity to implement simplicity~
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore
Try
Change the " " (Space) to your desired delimeter.
Code: Select all
Field(InputCol," ",Dcount(InputCol," "))