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

Recommended Answers

Lets see what you have tried so far.

Jump to Post

All 2 Replies

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.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.