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}"
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
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]
