Create a formula something like this:
left({job descrip field}, InStrRev({job descrip field}, '*') + 1)
(You may not need the "+ 1"....I always have problems remembering when to use it when working with parts of strings.) The "InStrRev" looks for the first asterisk from the right in the string and returns its position
Use this formula on your report instead of the field.
-Dell
Edited by hilfy - 27 Feb 2008 at 2:40pm
IP Logged
