Hi,
I am trying to import a CSV file , in which first row in each file contains information about the file ( where it came from etc ) and next row onwards are records.
[HEADER ROW] HD;1;2;BGRCM;AFGAW;04682;20160831061512;+0300;20160831053847;+0200;3;10;;;;BGN;;3;5;;20160831061512;+0300;[HEADER ROW]
[DATA]
MT;4XXXXXXXX;9XXXXXSSR;357807066041730;1;21;;TEST;;;20160830075130;+0300;0;;2;359898000100;4617306951892;;;;;;;;;;;;
CI;E;;;;;;0;246024;
MT;4XXXXXXXX;9FDFDD;XDSDEA;1;21;;TEST;;;20160830075132;+0300;0;;2;359898000100;4617306951903;;;;;;;;;;;;
CI;E;;;;;;0;246024;
MT;4XXXXXXXX;TEST;357807066041730;1;21;;TEST;;;20160830075136;+0300;0;;2;359898000100;4617306951911;;;;;;;;;;;;
CI;E;;;;;;0;246024;
I want guidance on how to process the header row and include data from header row in all of the rows in the same file.
The problem is that the header row has different fields from the data.