Programming

In my suggestion I used FS=\| and OFS=\| (not FS=| and OFS=| ) and also $0=$0 and not $0-$0 and I get:

Code:

1586|80100001|0389|70707|49121|5990|25002|41401|515|4019|56210|56999|||||||||||||||||||||||||||||||1|2|1|2|1|1|2|2|2|1||||||||||||||||||||||||||||||

Don't you?

Hi Scrutinizer

Yes, I'm getting that results,

for the work code all I should have is a total of 30 fields, the results you are getting is a total of 40 fields.

The output should be:

Same with the pri code fields there should only be a total of 30 fields.

Do I still have some thing wrong?

THX, gator5242

Just replace the 30's with 20's in my solution, or experiment with the right number.

Hi Scrutinizer

All input records will not have the same number of work codes or pri codes.
One input record might have one input work code, then I would need 29 blank field for the output record.
The input number of work codes and pri codes will be different for each employee.
The number of work codes and pri code could also be different for the same employee.
What do I need to change to have it work this way?
THX again for your assisance.

How about this:

Code:

awk -F\| 'function pr(){$0=s;NF+=30-m;$0=$0 t;NF+=30-n;print} 
          p!=$1 OFS $2{if(s)pr(); t=x; s=p=$1 OFS $2;m=n=0}
          $4""{s=s OFS $4;m++}
          $5""{t=t OFS $5;n++}
          END{pr()}' OFS=\| infile

Scrutinizer,

The work codes are working there is 30 output fields, but I'm only getting 29 output fields for the pri codes.
What do I need to change?
THX

I would suggest you experiment a little. Change the first 30 to 31 for example and see what it does...