TPT fixed length field with header and eof

Tools

TPT fixed length field with header and eof

hi,

i've got a fixed length file in entrance which contains a first line and an eof like this :

0120161019

02xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

02xxxxxxxxxxxxxxxxxxxxxxxxxxxxxe

992

 

the first two caracters is a field named id_occ

 

i define a file reader schema for occurs begin 02. i don't want the first and last row. i can delete it on unix with a sed command but in the tpt can i ignore it ?

 

for ignore first line i can use skiprow option but for the last line ?

 

is it possible with the AcceptMissing option and a where condition on id_occ='02' in insert order ?

 

thanks for response

1 REPLY

Re: TPT fixed length field with header and eof

When you are selecting from your dataconnector operator, add a WHERE clause:

 

WHERE id_occ = '02'

 

That will bypass any records from the file that do not have '02' in that field.