topic Re: Extract data after detecting particular information in a CSV file in Talend Studio

Extract data after detecting particular information in a CSV file

Mayot — Sat, 16 Nov 2024 08:01:39 GMT

Hello, I have a csv file (~ 40000 lines), at the beginning and at the end of the file I have technical information. I would like to retrieve particular information by detecting data :

"END OF REPORT","Selection Criteria"
,,,,,,,,,
,"Period:","05/2018",

I would like to extract the Period data after the END OF REPORT : "05/2018".

How can I do that ?

EDIT : Maybe I have to use Regex ?

Thanks

Re: Extract data after detecting particular information in a CSV file

fdenis — Fri, 29 Jun 2018 10:01:11 GMT

after reading data ad tmap with 1 boolean var named endOfCsvFile
first detect "END OF REPORT" to set it as true.
var.endOfCsvFile || row1.col1.equals("END OF REPORT")

filter the output of the tmap (stop sending data when endOfCsvFile is true)

add a new output to outPeriald add filter on this output
to retive row1.col3 only when row1.col2.equals("Periode")

Re: Extract data after detecting particular information in a CSV file

Mayot — Mon, 02 Jul 2018 14:18:16 GMT

Thanks for your reply. It works fine.