Extract data after last special character

[DimSum]

Hi, I'm trying to identify a way to script returning data after the last instance of a character, which may not be in each instance.  In the example below, that character is '-'.  Any help on this would be appreciated.

Data	Desired Result
ABC - 123	123
ABC - 1234 - 56	56
ABCD	ABCD

[edwin]

try subfield

[edwin · Accepted solution]

if you use 1 as the 3rd parameter it will give you the first component, if you use -1, its the last component when the text is parsed using a specific delimiter.  the delimiter can be a string, here is used ' - ' instead of '-':

[DimSum]

Thank you very much!

[edwin]

yw