Hi,
Anyone can help on how to re-aligned the data into one raw;
Input Text File:
TESTA Carbon A China 06/28/2016 Active Vol. 8210, No. 2048,
New Era 02/25/2010
(SCGC) Federal Register
TESTB Electric Intl China 06/28/2016 Active Vol. 8210, No. 2048,
Economic & 02/25/2010
Trading Co. Federal Register
TESTC Titanium China 06/28/2016 Active Vol. 8210, No. 2048,
Industry Co. 02/25/2010
Federal Register
TESTD Habibi Shaquil (HS) Iraq 06/28/2016 Active Vol. 8210, No. 2048,
02/25/2010
Federal Register
TESTE Mohammed Hezbollah (MH) Iraq 06/28/2016 Active Vol. 8210, No. 2048,
02/25/2010
Federal Register
TESTF Revolutionary Iran 06/28/2016 Active Vol. 8210, No. 2048,
Guardian Force 02/25/2010
Federal Register
Desired Output:
TESTA;Carbon A New Era (SCGC);China;06/28/2016;Active;Vol. 8210, No. 2048,02/25/2010 Federal Register
TESTB;Electric Intl Economic & Trading Co.;China;06/28/2016;Active;Vol. 8210, No. 2048, 02/25/2010 Federal Register
TESTC;Titanium Industry Co.;China;06/28/2016;Active Vol. 8210, No. 2048, 02/25/2010 Federal Register
TESTD;Habibi Shaquil (HS);Iraq;06/28/2016;Active;Vol. 8210, No. 2048, 02/25/2010 Federal Register
TESTE;Mohammed Hezbollah (MH);Iraq;06/28/2016;Active;Vol. 8210, No. 2048, 02/25/2010 Federal Register
TESTF;Revolutionary Guardian Force;Iran;06/28/2016;Active;Vol. 8210, No. 2048, 02/25/2010 Federal Register
Thanks in advanced.
Regards,
FSPalero