Search Results

Scrutinizer,

Thanks, changing the second 30 to 31 is working. I will do some more testing now and see what happen.
Thank you, gator5242

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

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...

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.

...

HI Scrutinizer,


THIS IS THE INPUT FILE

1-4 PROJECT
5-12 EMPLOYEE
13-14 SEQUENCE NO (MAYBE FROM 1 TO 30)
15-21 WORK CODE (MAYBE FROM 1 TO 30)
22-22 PRI CODE (MAYBE FROM 1 TO 30)...

Scrutinizer,

THX again for your help. I've been out sick for the past days.
I'll try your solution for option 2, and if I have any questions I will get back to you.
THX

Scrutinizer / ctsgnb

Thx you for responding to my request. I'm a novice awk programmer.
If you have the time, could you explain how your solution to the request works? Also how would option two...

Primary key is made up of the project and employee fields.

Yes they can.

---------- Post updated at 08:48 AM ---------- Previous update was at 08:33 AM ----------

They must be in order by their sequence number.

I need development help with a AWK Program.

1
2
3 THIS IS THE INPUT FILE – EACH EMPLOYEE MAY HAVE FROM 1 TO 30 RECORDS
4 INPUT
5 1-4 Project
6 5-12 Employee
7 13-14 Sequence (MAYBE FROM 1 TO...