This is my first post here.. I take this opportunity to thank all of you!!
My requirement is like combining 3 files in to a single output file , that too, i need to take few values (positions) from each input file and form a single line output file.
Example:
Input file 1:
DATE TRANSACTION TYPE TOTAL ORDERS TOTAL UNITS
---------- ---------------- ------------ -----------
2013-10-01 SHIPMENT 13,398 48,483
2013-10-01 RETURN 1,785 1,785
---------- ---------------- ------------ -----------
2013-10-01 SHIPMENT 13,398 48,483
2013-10-01 RETURN 1,785 1,785
Input file2 :
Cancld OMS OMS OMS OMS
Dnld Dnld Packed Packed Packed Sold Sold Cncld Cncld
Orders Units Orders Units Units Orders Units Orders Units
6,996 22,813 3,692 13,963 109 10,343 35,635 351 845
Dnld Dnld Packed Packed Packed Sold Sold Cncld Cncld
Orders Units Orders Units Units Orders Units Orders Units
6,996 22,813 3,692 13,963 109 10,343 35,635 351 845
input file 3 :
Date Total Orders Orders Shipped Orders Cancelled Items Shipped
10/01/2013 404 671 5 1059
10/01/2013 404 671 5 1059
Expected output file:
13,398 48,483 10,343 35,635 671 1059
The above values are from 3 different input files.
13,398 48,483 is from input file 1
10,343 35,635 is from input file 2
671 1059 is from input file 3.
10,343 35,635 is from input file 2
671 1059 is from input file 3.
Can anyone please help me with providing a code for this ASAP.
