Is this output what you need?
1,6,ea,456.321.07,"TRAY, BOTTOM, 66#47L-20503",2/9/2016
2,6,ea,456.321.12,"TRAY, TOP, 66#51R-20507",2/9/2016
3,1,ea,456.321.15,"TUBE, TALL, 66#15CR-21862",2/9/2016
4,8,ea,460.339.01,"WRAP, LGE GRP, xx#03CR-28081",2/9/2016
5,16,ea,460.339.02,"TRAY LGE GRP, xx#49R-27709",2/9/2016
8,2,ea,460.339.03,"WRAP, SM GRP, xx#02CR-28079",2/9/2016
9,4,ea,460.339.04,"TRAY, SM GRP, xx#50R-27711",2/9/2016
14,2,ea,456.325.30,"CNT LONG BOX BTM#08CR-23399",2/9/2016
15,2,ea,456.325.31,"CNT LONG BOX TOP#27L-23400",2/9/2016
16,2,ea,456.123.00," KIT ASSY BOX#F29487",2/9/2016
17,2,ea,456.147.00," KIT ASSY BOX 2, SC#F29494",2/9/2016
18,2,ea,456.325.11,"BOX, 34/43"", WMT UPR#11CR-20517",2/9/2016
19,2,ea,456.325.15,"BOX, 34""/42"" WMT UPR, BTM#13CR-21227",2/9/2016
21,5,ea,456.321.08,"TUBE, MEDIUM/SHORT, 66#14CR-20539",2/9/2016
22,5,ea,456.321.09,"TOP SPRT, 66#12CR-20504",2/9/2016
24,12,ea,456.321.11,"BRACE, MEDIUM END#22L-20505",2/9/2016
35,1,ea,456.325.10,"BOX, 22/29"", WMT UPR#18CR-20518",2/9/2016
37,1,ea,456.321.29,"TRAY, BTM, 94#45L-20549",2/9/2016
38,1,ea,456.321.30,"TUBE,MED/SHORT, 94#05CR-20550",2/9/2016
39,1,ea,456.321.31,"SPRT, TOP, 94#04CR-20501",2/9/2016
40,1,ea,456.321.32,"TRAY, TOP, 94#43R-20548",2/9/2016
This cuts off the last 2 columns. Also for all the other columns, only the cols from the first occurrence are used.
You said this data was going to be used in another program or processed further in a larger program. Maybe it would be helpful to describe what is needed to be done.
