Severing LAUS codes

[shocking]

Hi,

I'm working with some Data from the BLS website which I need to cut down to another code form (CBAS). In order to that I need to remove the first five letters (which form an acronym describing the data) and the first two numbers (which represent the FIPS state code) as well as the last number (which indicates the data type).

For example:

LAUMC01107603

with the portions that need to be removed in parentheses

(LAUMC01)10760(3)

would become

10760

I need to do this for a column of these codes which contains about a thousand entries.

Thanks