topic Re: Read file.dat with tfileinputregex in Talend Studio

Read file.dat with tfileinputregex

INESBK — Tue, 23 May 2017 16:09:28 GMT

Hi,

I would like to read file.dat with tfileInputRegex.

Here is a screenshot of the file:

So,I need to distinguish the parts of the file by the beginning of the word "LB" because each time there is an LB it is new data to extract and i need to retrieve three fields that are framed in red.

I tried these exprssions but I still get an error

"^LB"+
"([A-Z]\\.*)"+
"^([0-9]{8}T[0-9]{6}\\.[0-9]{3}Z)"+
"([0-9]*\\.[0-9]*)|(^-[0-9]*\\.[0-9]*)|[\\?]"

Thanks in advance.

Best regards.

Re: Read file.dat with tfileinputregex

TRF — Wed, 24 May 2017 20:37:34 GMT

Your explaination is not very clear as you speak about 3 fields circled in red but there only 1 for lines starting with LB. Also, you don't say anything about other fields also circled in red.
I suggest you to give us the expected result based on this sample.

Re: Read file.dat with tfileinputregex

INESBK — Wed, 24 May 2017 22:37:50 GMT

I try to be clear
The file.dat contains values from several sensors. I can distinguish the data of a sensor by the LB. When there is LB, it means a new sensor

I need to create 3 fields (name, value, date) to recover the fields of the sensors
-Name (which is the name of the sensor) is in the line that contains LB
-value,date begen starts from the third line until the start of a new sensor (an anothor line with LB)

Knowing for value I can find negative values or "?" or simple value

Here is the expected result:

My need is to create a pattern with regex to create this fields.

Thanks in advance.

Re: Read file.dat with tfileinputregex

Anonymous — Sun, 03 Jun 2018 13:21:39 GMT

you can achive this using tfileinputdelimited also. Only in column0 you have to put LB externally.