I'M totally new to this stuff but I have set up a functional environement on a raspberry pi 4 containing mosquitto, grafana, node-red, influxdb and telegraf.
I am able to send messages via mqtt (from, for example, for testing purpose from MQTTbox or from a ESP32/MCU) to node-red. I also can forward these data to an influxdb. But unfortunately the data is written as one big string to a colomn called value.
This is the mqtt message: "room=bath, temp=25, hum=65"
I want to send all environment messages to one topic (sensors/env) and use the message to split the content to different colomns. similar to this:
can you give me an example, which I could use to reach this goal? just to split a mqtt message to different parts to write as seperate colomns to the influxdb.
hope someone can help me.