https://community.qlik.com/t5/Talend-Studio/Extract-lines-from-text-file-with-talend/m-p/2273874#M50723 Hello,<BR />I a newbie with Talend and I'm trying to extract some lines from a text file to insert data in database.<BR />The file has the following format :<BR />head<BR />N lines with format 1<BR />N lines with format 2<BR />foot<BR />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...<BR />Thanks in advance for your help and advice. Sat, 16 Nov 2024 13:05:59 GMT Anonymous 2024-11-16T13:05:59Z https://community.qlik.com/t5/Talend-Studio/Extract-lines-from-text-file-with-talend/m-p/2273874#M50723 Hello,<BR />I a newbie with Talend and I'm trying to extract some lines from a text file to insert data in database.<BR />The file has the following format :<BR />head<BR />N lines with format 1<BR />N lines with format 2<BR />foot<BR />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...<BR />Thanks in advance for your help and advice. Sat, 16 Nov 2024 13:05:59 GMT https://community.qlik.com/t5/Talend-Studio/Extract-lines-from-text-file-with-talend/m-p/2273874#M50723 Anonymous 2024-11-16T13:05:59Z https://community.qlik.com/t5/Talend-Studio/Extract-lines-from-text-file-with-talend/m-p/2273875#M50724 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... Wed, 09 Feb 2011 19:13:19 GMT https://community.qlik.com/t5/Talend-Studio/Extract-lines-from-text-file-with-talend/m-p/2273875#M50724 Anonymous 2011-02-09T19:13:19Z