Member Avatar for jovillanuev

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

  • 3 Contributors
  • 2 Replies
  • 67 Views
  • 15 Hours Discussion Span
  • Latest Post Latest Post by adam_k

Recommended Answers

All 2 Replies

Member Avatar for debasisdas

Lets see what you have tried so far.

Member Avatar for adam_k

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