topic The columns have null values in tFileInputRegex in Talend Studio

The columns have null values in tFileInputRegex

Anonymous — Wed, 13 Jul 2016 14:39:00 GMT

Hello, I am a new user of Talend, trying to use tFileInputRegex to extract lines of data from a text file. Each line will be separated into 7 columns. The schema of the columns and the test data file are attached here. Following is the regex used for the line extraction. All the extracted columns have only null values. Any suggestions will be greatly appreciated!
"[A-Z]+[0-9]+\\s+[0-9]+\\s+[A-Za-z\\s]+-?[0-9,]+.[0-9][0-9]\\s+-?[0-9,]+.\\d{2}\\s+-?[0-9,]+.\\d{2}"

rainbow_reg_test.txt_20160713-0636.txt

Re: The columns have null values in tFileInputRegex

Anonymous — Thu, 14 Jul 2016 09:26:37 GMT

Hi,
The attachment < rainbow_reg_test.txt_20160713-0636.txt>you provided is not valid on forum. Could you please take a look at it?
Could you please paste your file into forum directly?
Best regards
Sabrina

Re: The columns have null values in tFileInputRegex

Anonymous — Fri, 15 Jul 2016 16:57:09 GMT

Thanks for the response! I have tried another way and got through it.

Re: The columns have null values in tFileInputRegex

Anonymous — Mon, 18 Jul 2016 05:20:43 GMT

Hi zenghc,
Would you mind sharing your solution with us?
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif]Best regards[/font][/color]
[color=#5b5b5d][font=Verdana, Helvetica, Arial, sans-serif]Sabrina[/font][/color]