I can send it in/out MQTT and extract the number with a change node (as it becomes an object), but if I treat it like a string in a change node It fails. What am I missing? I must be misunderstanding the change node.
Thanks
I try delete everything before and after the number (change node & 2 rules replacing front and back with empty) and I only delete the end bit every time.
Have you tried sending it through a JSON node, which should convert it to an object if it is valid JSON?
Edit: Oh, you are sending it through a JSON node. I suggest you do that immediately on getting the data, then you can work with it as an object which should make the whole thing easier. The MQTT Out node will be happy with it as an object.