Hi,

I need to be able extract a string from within a longer string. The information I want will always start 5 chracters in and be bordered by an underscore either side, but could be of any length. For example in the following string, I would want to extract WF602.

DDR_WF602_____02_00_001_FLANGE_WR34_4_HOLE_PLAIN_CLEARANCE

I've been looking at the RegExp functions but can envisage problems with this as later parts of the string (WR34) have the same form as the part I need.

I can get rid of the first 4 characters using

A = Len(PartCode)
        A = A - 4
        PartCode= Right(PartCode, A)
But am having a mind blank and unsuccessful searches on how to remove the rest of the string

Any hints would be appreciated,

Thanks