Hi,
I need to extract and validate data from file with fix-length .It has multiple records of different structure.Value of a field RECID identifies the record as header,detail or trailer record.RECID with value H1234 will be header,RECID with value D1234 will be detail and RECID with value T1234 will be trailer. File will have data in following format
H1234 12345 12345678901234567890 abcde
D1234 12345 12345678901234567890 abcde abcde
D1234 12345 12345678901234567890 abcde abcde
T1234 12345 12345678901234567890
Please advice how this is acheivable by CloverETL.