- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.