topic Re: Extract data after last special character in App Development

Extract data after last special character

DimSum — Thu, 02 Feb 2023 19:14:27 GMT

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

Re: Extract data after last special character

edwin — Thu, 02 Feb 2023 19:41:19 GMT

try subfield

Re: Extract data after last special character

edwin — Thu, 02 Feb 2023 19:44:19 GMT

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 '-':

Re: Extract data after last special character

DimSum — Thu, 02 Feb 2023 20:23:19 GMT

Thank you very much!

Re: Extract data after last special character

edwin — Thu, 02 Feb 2023 21:40:16 GMT