Pulling only certain characters from a field

[aj3221]

I have a field (customer PO#) that has a 4 digit # which means nothing to us, then a “-“ dash, then a 2 character alpha-numeric code. I want to capture the 2 characters after the dash, not the entire #.

PO#
5200-C3
5200-H6

I want the report to show:

PO#
C3
H6

 

[Madawc]

Is 'PO#' a heading? If so, you could get the part you want by

Right({your.field}, 2)

if lengths vary, you might use MID, or REPLACE to get rid of the 5200-. Or SPLIT on the dash.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP