topic Read Specific Record from txt file in Talend Studio

Read Specific Record from txt file

Anonymous — Wed, 27 Mar 2013 11:37:14 GMT

Hi All,
My source is a Delimited file. I have around 1000 records. First record contains only date to identify that file is today's file. How can I read the first line alone for validation? And also assist on how to read a specific record from a file( for example 10th record,100 th record etc,.) .

Kindly assist.
Thanks,
Saty.

Re: Read Specific Record from txt file

Anonymous — Wed, 27 Mar 2013 13:11:50 GMT

Hi
To read the first N line, you can set the Limit field on tFileInputDelimited to let the component only read the first N line, for example, set Limit as 1 to read the first line. To read a range of lines, for example, from 10th line to 20th line, you can use tSampleRow component.
Shong

Re: Read Specific Record from txt file

Anonymous — Thu, 28 Mar 2013 05:12:36 GMT

To read the first N line, you can set the Limit field on tFileInputDelimited to let the component only read the first N line, for example, set Limit as 1 to read the first line. To read a range of lines, for example, from 10th line to 20th line, you can use tSampleRow component.

Thanks Shong. I have one doubt. I have N no. of records in a text file. How can I select last record from the this file?
Kindly assist.

Re: Read Specific Record from txt file

Anonymous — Tue, 09 Apr 2013 05:03:51 GMT

I have N no. of records in a text file. How can I select last record from the this file?

Hi All,
Kindly someone assist on this.

Re: Read Specific Record from txt file

alevy — Wed, 10 Apr 2013 00:34:00 GMT

The best way is probably to use tFileRowCount to get the number of records and then pass that as a variable to tFileInputDelimited's Header field (-1).