Want to laugh?
Sometimes we are inclined to think that the solution to our problems is complicated and so we look for complicated solutions.
But we don't see that the solution is sometimes simple and trivial and it's right there in front of us.
But we look for the complex solution.
My goal was to get a time log of some values.
Like this
15-Feb-2021;21:37;1;20;19.2;19.2;
15-Feb-2021;21:37;1;20;19.2;19.2;
15-Feb-2021;21:37;1;20;19.2;19.2;
15-Feb-2021;21:37;1;20;19.2;19.2;
to have a CSV exportable in excell
therefore I have generated this rule
Append to LogTermostatVirtual: %date%;%time%;%aux_ReleCaldaia%;%aux_SetTermostato%;%aux_TemperatureMedia%;%aux_Temperature1%;
and then I wondered how do I generate CRLF? because the result was this....
15-Feb-2021;21:37;1;20;19.2;19.2;15-Feb-2021;21:37;1;20;19.2;19.2;15-Feb-2021;21:37;1;20;19.2;19.2;15-Feb-2021;21:37;1;20;19.2;19.2;
So I tried to add special characters \n \r....
Days and days of thinking and googling and asking you guys for advice....
Then tonight I looked at the rule I clicked at the end of the line and hit enter....