topic Reading lines between two strings in a file in Talend Studio

Reading lines between two strings in a file

AJ151 — Sat, 16 Nov 2024 01:45:31 GMT

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.

Re: Reading lines between two strings in a file

Anonymous — Mon, 03 Aug 2020 04:38:01 GMT

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