Field data I already have: 03-1A3B5C7

Field data I need: 1A3B5C7

Is there a way to strip the "03-" from data that begins specifically with "03-" (some won't have an 03- or may have 03 with no dash as part of number, which I'd want to leave alone) to get the field data I need?

Any shove in the right direction would be appreciated. JW

If the pattern is always 03- and the field will not have a second 03- in it, the you can use this calculation in a field

Substitute ( Your_Field, "03-", "")

Lee

Edited February 16, 200619 yr by Guest

If you might have another occurance of 03- then

If(Left(Text;3) = "03-", Right(Text;Length(Text)-3),Text)

Thanks so much - I was able to use both (for different fields) with splendid results!