Hi All,
I'm using GZip CSV input step to read a CSV file which is in the tar.gz file. The csv file inside the tar.gz file has .del extension not the .csv extension. If I run the transformation, the first row first column shows the tar file header information with the actual data in the column. Can we remove this header information in the first row first column and have only the data in it?

I tried with text file input with compression as GZip and the header information is shown in the first row first column.

The first row first column has data like "TheInputFileName some numeric values " with "ustar" with "Alphanumeric numbers" with "ActualData".

Did anyone face this issue? Your help on this will be much appreciated.

Thanks,
A.M.Bupathi Rajha