Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
you can achive this using tfileinputdelimited also. Only in column0 you have to put LB externally.