extract part of a string

[sheriberi]

I have a string of data that is a concatenation of a various number of items separated by a , I need to extract the last value every time. How can I write that formula?

 

[fisheromacse]

i do not have crystal in front of me, so apologize for any typos or syntax errors.

I think you can do something like this:

Split({YourTable.YourField},",")[Ubound(Split({YourTable.YourField},","))]

 

[AndyMc]

Or
Mid({YourTable.YourField},instrRev({YourTable.YourField},",")+1)