You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-03-14 18:32:12

tobbet
Member
2 posts

tobbet said:

null outputs from tFileInputRegex

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

mini_Image_275-2017-03-14.jpg 
mini_Image_276-2017-03-14.jpg

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)

Offline

#2 2017-03-15 07:56:35

xdshi
Talend Team


xdshi said:

Re: null outputs from tFileInputRegex

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


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2017-03-15 09:49:36

tobbet
Member
2 posts

tobbet said:

Re: null outputs from tFileInputRegex

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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy