Hi,
Good Morning !!
Can you help me with the situation mentioned below; My requirement is to pull 2 fields from record 1 and 2 fields from record 2 as ONE OUTPUT record; I knew that every two records is a set here.
INPUT
-------
8E03402723N10050238376
1B03402723VNPETALUMA POULTRY
8E0SKEXCELN1005032667700009
1B0SKEXCELVNHOUSTON
8E0SKEXCELN1005033044200052
1B0SKEXCELVNDALLAS
8E0SKEXCELN1005021666100540
1B0SKEXCELVNLOUISVILLE
8E03402089N10050238374
1B03402089VNBOULDER NATURAL MEATS
8E03000684N10050244617
1B03000684VNCHEF'S REQUESTED FOODS
Expected OUTPUT (2 pos from 1 and 7 pos from 4 from rec 1 AND 2 pos from 1 and 20 pos from 13 from rec 2 as 1 OUTPUT record)
----------------------
8E34027231BPETALUMA POULTRY
8ESKEXCEL1BHOUSTON
8ESKEXCEL1BDALLAS
8ESKEXCEL1BLOUISVILLE
8E34020891BBOULDER NATURAL MEATS
8E30006841BCHEF'S REQUESTED FOODS
Options :-
1. First record will always have 8E in first 2 positions.
2. Second record will always have 1B in first 2 positions and VN in 2 positions from 11.
Let me know if you need any information from my end.
Thank You.
Rajesh.