Splitting Data after a Semicolon

[cguyreports]

I am using crystal xi and have a field and I need everything to the right of the last semicolon. But the last semicolon is not always the same characters from the right.

Examples
Store1:Westpark Towne Plaza:t (I would need to show the t)
Store4:Eastgate:n01 (I would need to show the n01)
Store6:Hickory Hollow Mall:ex (I would need to show ex)

Any suggestions would be great.
Thank you!

 

[lbass]

Try:

right({table.field},instr(strreverse({table.memo}),":")-1)

You could also use:

split({table.field},":")[ubound(split({table.field},":"))]

Note that you displayed a colon, not a semi-colon, so I used colons in the formulas.

-LB

 

[cguyreports]

Awesome! They both work. Thank you so very MUCH!!!!