Reading lines between two strings in a file

[AJ151]

Hello everyone,

I want to read lines between two particular strings in a file.

Eg : AAA 34567 5678

BBB HFDT ₹556

CCC YU UKK45

BBB YUHJ IOKH

DDD​ UUU IHJK

The order may keep changing but I need all the lines starting from CCC till

DDD.

Is​ it possible in talend? Could you please help with it.

Note: The data is only in file format..

Iam new to talend. Kindly help with this. ​

[Anonymous · Accepted solution]

Hi

My idea is to get the line number of lines that starts with 'CCC ' and' 'DDD' respectively, and then to read the lines between the range of line_number1 to line_number2 using tSampleRow, see

In your case, use tFileInputFullRow instead of tFixdFlowInput to read the file line by line. Please try and let me know if you have any questions.

Hope it gives you hints!

Regards

Shong