One Star

Extract lines from text file with talend

Hello,
I a newbie with Talend and I'm trying to extract some lines from a text file to insert data in database.
The file has the following format :
head
N lines with format 1
N lines with format 2
foot
I just want to extract only the lines with format 2, I managed to read the file with the component tFileInputFullRow but I can't succeed to get only the the lines with format 2 and cut it to insert data in base...
Thanks in advance for your help and advice.
1 REPLY
Six Stars

Re: Extract lines from text file with talend

you could try multischema (MS) components if you have a record type id... otherwise of course you need some hint in the data to discriminate between formats...