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?
Last edited by tobbet (2017-03-14 18:36:21)
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?
What we can do is to make sure that Talend will be your best choice!
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)