I would like to read data from a CNC machine using mqtt. The broker data is not key/value pairs but a comma separated string and depending on the MQTT topic the strings are of different length. E.G.:
Using CSV I was able to parse the data, but there are 2 problems:
is there any way to define the CSV structure for each MQTT Topic separately? At the moment I create a completely new section for each topic which establishes an additional connection to the broker.
it was not possible to parse date and time correctly. When I remove the miliseconds in the date definition, the date is parsed, but is wrong. With the specification of the miliseconds I get the message that the “. cannot be processed as +02:00”.