need to remove header and trailer from file

hargun · Post by **hargun** » Fri Feb 13, 2015 8:40 am

hi,

i am reading comma separted sequential file layout as follows

Header ---20150606NameOfile
Columname-columnID

records

trailer

i need to remove header ,column names and trailer so that i will load the records into the table.

i tried with filer option command sed '1d;$d' which only stripping the header and trailer part not the column name part and due to which i am not able to read the file.can you please help me on this.

chulett · Post by **chulett** » Fri Feb 13, 2015 8:59 am

This should happen automagically in PX if the stage only includes the actual metadata for the detail records. Then anything that doesn't match (i.e. everything else) should reject.