UPDATE:
There is no InStrRev function (yet) in the calculation stage....
If you don't want to go into RegEx, and you want to get the last name...
Make a new object (e,g. named: Get last name)
In the object make a code stage, and put the following code in:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
'IN: Full_Name (Text)
'OUT: Last_Name (Text)
if Full_Name.IndexOf("" "") > 0 then
Last_Name = Full_Name.Substring(Full_Name.LastIndexOf("" "") +1)
end if
********************************************************************
The above worked a treat.
Thank you
