I have a field with a value at the before a "-" that varies in length and text after the dash. I would like to get a sub set of the portion before the dash. I've seen comments on how to extract after a certain point but not before and not if the length varies.
OLB-20 in original field
OLB should be in calculated field
OLBad-1539 in original field
OLBad should be in calculated field