Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
tobbet
Contributor
Contributor

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

 


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? 

Labels (2)
2 Replies
Anonymous
Not applicable

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
tobbet
Contributor
Contributor
Author

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