Right Function

  • Thread starter Thread starter Bill Beshlian
  • Start date Start date
B

Bill Beshlian

Hello,

I receive data that includes a field named ExternalClaimNumber. The
ExternalClaimNumber is a concatination of three numeric values and is
returned in this format: 11111-111111-11, 11111-111111-111,
11111-111111-1111. I am interested in the last two, three or four digits of
this field. Is there any way the Right Function can me modified to trim to
and stop at the "-" so I can capture the last two, three or four digits?
Thanks!

Bill Beshlian
 
The follwing expression should do the trick:


mid([FieldName],instrrev([FieldName],"-") + 1)
 
Back
Top