## TPT fixed length field with header and eof

Tools & Utilities
Enthusiast

## 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

Highlighted
Enthusiast

## 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.