Formula Help Needed - Need to shorten field 1

[rico7937]

Hello all,

I am using Crystal Reports V10. I am trying to figure out how to shorten a field and not sure how to do it.

I run a network report with a field called

outage_data.resource_id (string field) that produces the following output
(About 400 various Id's in this format) VFC-EC7MRTR1.

What I am looking for is to create a formula that will knock off the first 4 characters "VFC-" and anything after characters # 8 ( Ex. VFC-EC7MRTR1 to look like EC7M ).

Any suggestions on how to do this would be greatly appreciated amd timely too since I have to produce this
for the quarter end reports coming up. Thanks !

 

[CR85user]

Try:

mid({outage_data.resource_id},5,4)

'J

 

[rico7937]

Thank you so much, that worked just fine !