how to extract the last row of a .dat file which the length is always different

[Cpages]

Dear all,

We need to extract the last row of a .dat file, but we are not able to define how to identify the last one because at each execution the file doesn't have the same number of rows.

we tried to use tFileInputMSPositionnal component but we don't have a discriminating factor.

Is there any other component that can help us ?

Thanks in advance for your help.

Regards,

L &C

[tnewbie]

Hello,

Step 1:

Have a tFileRowCount component which can count the number of lines in the .dat file

Step 2:

Use a sequence in a tMAP and fetch only the last row (equate your sequence to the row count you get from tFileRowCount)

 

 

Hope this helps