Having a text formula read right to left

[chrismilardo]

Hi everybody,
I've got a formula I have been working on to parse out the last name in a text field; the formula is long b/c of the potential for first/middle names, initials, etc. If I could get the formula to read the text from right to left, I could just use the text in the field up to the first space. Does anyone know what operator I would use to get the formula to "read in reverse"? Thank you!

 

[kenhamady]

If you have V8, there is a new function called InStrRev() that works from the right.

In other words it finds the last occurance of the string but gives you the position of that character as counted from the left, so you can use the position number in the substring operator brackets. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal