topic Re: null outputs from tFileInputRegex in Talend Studio

null outputs from tFileInputRegex

tobbet — Tue, 14 Mar 2017 17:32:12 GMT

Hi,
I have a most likely trivial problem I can't seem to figure out.

I have an input-file ( just a normal txt file) with /n line feed, and I want to find the rows that starts with the word "Line". Where it matches I need to get the full row in the output.
The job looks like pic 1

The reg-exp I am currently using gets me 7 matches ( "^.*Line.*$" ) but the rows coming out are just blank (null in a table view)
What am I doing wrong?

Re: null outputs from tFileInputRegex

Anonymous — Wed, 15 Mar 2017 06:56:35 GMT

Hi,
Could you please check out "Die on error" option on tfileinputregex component to see if there is any error message printed on console?
What does your input look like?
Best regards
Sabrina

Re: null outputs from tFileInputRegex

tobbet — Wed, 15 Mar 2017 08:49:36 GMT

The die on error is unchecked.
I have put a checkmark in the box for "Ignore error message for unmatched record" to get only the matching lines in the output.
The infile looks like this..
==
Inaktiverar alla anställningar
7988 påverkade rader, Exekveringstid: 187,58 ms
Line 531: Fel vid inläsning av person: Query returned more than one row
Line 1287: Felaktigt personnummer: XXXXXXXX (Kod=476)
Line 2301: Fel vid inläsning av person: Query returned more than one row
Line 7526: Personnr [XXXXXXXXX]: Felaktigt anställningsdatum [500301 Etnologi]
===
so in the sample above I want to get only the rows starting with "Line" (4 rows)
/Tobias