Right Function

[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

 

[Albert D. Kallal]

The follwing expression should do the trick:


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

 

[Bill Beshlian]

Thanks Albert. I got the result I was looking for.

Bill Beshlian