Have just dumped a pile of log entries into Excel from Domoticz. I'd like to split them up so I can look at them and, to save me reinventing the wheel, I wonder if anyone has written an Excel macros/formulas to assist with this? I'd like to split:
18/06/2021 10:26 (4) FAULT: COMMS FAULT on ACTUATOR(11a5e2) at 2021-06-18 10:27:48
Into date/time, type (fault/restore) and convert the hex for the device to a name I can understand. Nothing is particularly hard, but I'd be interested to see if anyone has done anything.
18/06/2021 10:26 (4) FAULT: COMMS FAULT on ACTUATOR(11a5e2) at 2021-06-18 10:27:48
Into date/time, type (fault/restore) and convert the hex for the device to a name I can understand. Nothing is particularly hard, but I'd be interested to see if anyone has done anything.
Comment