Code: Select all
Account Number,GroupCycle,GroupName,CustomerNumber
000031973,1,BENSONHURST FAMILY VISION,00668360
000034970,1,BLANE CASEY BUILDING CONTRACTO,00792198
000070739,1,"D & D COLLISION SERVICES, INC",00524910
1) I do not need the 1st row (the header) in my o/p.
2) The last column (customer number) values should be the 1st column in my o/p file,
3) The first column (Account number) should be the 2nd column in my o/p file.
The o/p file should look like this -
Code: Select all
0668360 000031973
0792198 000034970
0524910 000070739
This is the sort card that I attempted, but I know there has to be something more to it -
Code: Select all
OPTION COPY
OUTREC PARSE=(%01=(ENDBEFR=C','FIXLEN=14),
%02=(ENDBEFR=C','FIXLEN=10),
%03=(ENDBEFR=C','FIXLEN=9),
%04=(ENDBEFR=C','FIXLEN=14))
BUILD =(%04,%01)