Regarding Substring

Reply
Frequent Contributor
Posts: 90

Regarding Substring

Hi

I have the below data,

cl_No lineno Servive_code
1       01      120
2       01      D373
2       02      373
2       03      D440
3       01      270
3       02      D20
3       03      D4567
3       04      D567
3       05      F679

The service_code should include a 3 digit service_code and a 4 digit service_code.
The four digit servie_code should begin with the letter "D" and is the last of the
cl_no.

The output should be like this:

cl_No lineno Servive_code
1       01      120
2       02      373
2       03      D440
3       01      270
3       02      D20
3       04      D567

Thanks in advance

Super User
Posts: 11,343

Re: Regarding Substring

Are you looking to keep records:

when the service code is exactly 3 characters they are all digits or any exactly 3 character code?

or

when the service code is exactly 4 characters the first first character is "D"?

I'm not sure what you mean by "and is the last of the cl_no" since your have multiple cl_No values in your output example.

Ask a Question
Discussion stats
  • 1 reply
  • 127 views
  • 0 likes
  • 2 in conversation