Display last value in a string

[#1]

Hi All,

hope you could help me with the following issue.

lets say I have a field which contains the following values:

'ABC>AB>A'

'ABCD>ABBBC>AD>D'

'MMMN>MKL>KLL>KLLL>L'

I want to create a new dimension that will display the values after the last '>' (the result will be: 'A','D','L'). I don't know how many characters will be before the last '>'.

is there a function I can use?

Hope I was clear enough.

thanks in advance

[antoniotiman · Accepted solution]

Hi Michal,

=Subfield('AAA>BBB>ACCC >L','>',-1)

Regards,

Antonio

[PrashantSangle]

hi,

Try this

subfield('MMMN>MKL>KLL>KLLL>L','>',len(KeepChar('MMMN>MKL>KLL>KLLL>L','>'))+1)

replace string with field

Regards

[#4]

Thank you!