Guys,

I have those records. how to i removed the first 10 records and the last 2 records(-U)in string.

P300-1110-C731-U
P300-1110-INCREDIBLE-U
P300-1710-DEVOUR-U
P300-1710-DROID2-U
P300-4410-THUNDRBLT4G-U
P333-4110-8530-U


Here is the correct Result:

C731
INCREDIBLE
DEVOUR
DROID2
THUNDRBLT4G
8530

Thanks in Advance.

Jonel

Lets see what you have tried so far.

You need to read about len and substring functions or left, right and len functions.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.