All information would be on one line but the carriage return was forced when typing into the area for this post.
Basically, I want to keep only the first occurence of the information in colums 1 and 2. I then want to list the information in column 3 from left to right in the same row. I want to do this for each new number listed, ie: one row that looks like the example above for 2131100 another row for 2131200 etc...
Attached below is a copy of the AWK script which does not seem to be working properly.
Any insight on how to accomplish this would be greatly appreciated.
thank you for the response. Any idea why the script suggested would be producing output that contains 2 occurences of the 2nd field?
Any thoughts are welcome. Also, if an example of input and/or output would be helpful I can provide them.
Thank you.
Please do provide an example of the input you used that caused a problem, as well as the output you saw. The output I get from the example input you posted originally is:
2131100 COVS/100C E|FWP AREAS|MIDWEST|CONSTRUCTION|FTC|FWP AREAS|CLEANING|FCRE|
2131200 COVS/100C UPS|UPS ROOMS|CONSTRUCTION|UPS ROOMS|FCRE|EMERGENCY|