topic Re: Find a string and and extract data in line next to it in Talend Studio

Find a string and and extract data in line next to it

amenardie — Fri, 15 Nov 2024 21:22:58 GMT

Hello,

I'm trying to extract data in an excel file which is just next to a string I would find by regex or any other way.

As you can see in the screenshot, there are multiple sections and i'm trying to extract the information "AD" just next to "[Comments].

I cannot extract a line count for this section and filter on it as it won't be at the same place. The files i will process do not contain all the same informations so it can be earlier or later in the document.

It maybe is easy, but i'm not seeing how to do it right now.

Have you any ideas how to achieve what I want ?

Thank you.

Re: Find a string and and extract data in line next to it

Anonymous — Wed, 27 Sep 2023 04:47:01 GMT

Using tMemorizeRow to store the last row, read each line from Excel file, check if last row contains "[Comments]", if so, extract the value of current row, the job looks like:

tFileInputExcel--main--tMemorizeRow---tJavaRow

Take a look at the component documentation of tMemorizeRow

https://help.talend.com/r/en-US/8.0/tmemorizerows/tmemorizerows?tocId=PgOSyP91mt_dn5Fsn3EqXQ

Let me know if you have any questions.

Regards

Shong

Re: Find a string and and extract data in line next to it

amenardie — Mon, 02 Oct 2023 11:46:35 GMT

Hello @Shicong Hong,

I'm sorry, I don't really see how to achieve what you suggested as I never used tMemorizeRow.

Do you have any detailed exemple on what i can set up in my case ?

Thank you for your help!