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