Hi All, I have a requirement where I need to merge multiples lines records into single. Each row length in 80 bytes. The challenge is that that each record that is spread in multiple lines is dynamic in number of lines i.e. 1. a new record is identified by a line having '=============….' 2. After the above record, there are 2 lines which has same structure for every record 3. From 4th record, there can be multiple records with same structure and it will be dynamic (1 or 2 or 3 lines...) So I need to ignore the 1st line indicating new record (i.e. one with '========...'), merge line 2 and line 3 for each line in the next lines... e.g. =============================================================================== UNIQUEID_RECORD00001 2018-06-05 01:00:00 USER001 FNAME1 MNAME2 LNAME1 00001 PERSONAL_RECORD_00000000001 00000000000000000001 JOBPRFL1 CITY0001 CODE1 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 CITY0002 CODE2 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 =============================================================================== UNIQUEID_RECORD00002 2018-06-05 01:00:00 USER002 FNAME1 MNAME2 LNAME1 00002 PERSONAL_RECORD_00000000001 00000000000000000002 JOBPRFL2 CITY0003 CODE3 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 CITY0004 CODE4 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 CITY0005 CODE5 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 CITY0006 CODE6 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 =============================================================================== UNIQUEID_RECORD00003 2018-06-05 01:00:00 USER001 FNAME1 MNAME2 LNAME1 00003 PERSONAL_RECORD_00000000003 00000000000000000031 JOBPRFL3 CITY0002 CODE2 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 output should be UNIQUEID_RECORD00001 2018-06-05 01:00:00 USER001 FNAME1 MNAME2 LNAME1 00001 PERSONAL_RECORD_00000000001 00000000000000000001 JOBPRFL1 CITY0001 CODE1 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 UNIQUEID_RECORD00001 2018-06-05 01:00:00 USER001 FNAME1 MNAME2 LNAME1 00001 PERSONAL_RECORD_00000000001 00000000000000000001 JOBPRFL1 CITY0002 CODE2 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 UNIQUEID_RECORD00002 2018-06-05 01:00:00 USER002 FNAME1 MNAME2 LNAME1 00002 PERSONAL_RECORD_00000000001 00000000000000000002 JOBPRFL2 CITY0003 CODE3 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 UNIQUEID_RECORD00002 2018-06-05 01:00:00 USER002 FNAME1 MNAME2 LNAME1 00002 PERSONAL_RECORD_00000000001 00000000000000000002 JOBPRFL2 CITY0004 CODE4 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 UNIQUEID_RECORD00002 2018-06-05 01:00:00 USER002 FNAME1 MNAME2 LNAME1 00002 PERSONAL_RECORD_00000000001 00000000000000000002 JOBPRFL2 CITY0005 CODE5 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 UNIQUEID_RECORD00002 2018-06-05 01:00:00 USER002 FNAME1 MNAME2 LNAME1 00002 PERSONAL_RECORD_00000000001 00000000000000000002 JOBPRFL2 CITY0006 CODE6 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1 UNIQUEID_RECORD00003 2018-06-05 01:00:00 USER001 FNAME1 MNAME2 LNAME1 00003 PERSONAL_RECORD_00000000003 00000000000000000031 JOBPRFL3 CITY0002 CODE2 ADDRESS1 ADDRESS2 ADDRESS3 PINCODE1
... View more