Or without using a csv node
[{"id":"fd38109caf3339c8","type":"inject","z":"d1395164b4eec73e","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":" ;{};{\"desc\":\"blabla\",\"label\":\"\"};[];","payloadType":"str","x":110,"y":1000,"wires":[["7482b754f74fe218"]]},{"id":"7482b754f74fe218","type":"template","z":"d1395164b4eec73e","name":"","field":"payload","fieldType":"msg","format":"handlebars","syntax":"mustache","template":"#;Vertices of type codecVertex\n#;active;bidirPartnerId;codecFormat;configPriority;control;custom;descriptor;extraAlertFilters;Factory label;isIgmpSource;mainDstIp;mainDstMac;mainDstPort;mainDstVlan;mainSrcGateway;mainSrcIp;mainSrcMac;mainSrcNetmask;public;sdpSupport;sipsMode;spareDstIp;spareDstMac;spareDstPort;spareDstVlan;spareSrcGateway;spareSrcIp;spareSrcMac;spareSrcNetmask;tags;useAsEndpoint\ndevice73.484735f6-a1ea-596e-8282-0cd1108e6be2.R01a52f67-554c-5791-8503-fcbee07f93d9;true;null;Audio;off;off;{};{\\\"desc\\\":\\\"\\\",\\\"label\\\":\\\"\\\"};[];receiver_s06_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false","output":"str","x":240,"y":1000,"wires":[["ff08c76f142a3059"]]},{"id":"ff08c76f142a3059","type":"function","z":"d1395164b4eec73e","name":"function 145","func":"let line_skip = 1;\nconst separator = \";\";\nconst output = []\nlet lines = msg.payload.split(\"\\n\")\nlet keys = lines[line_skip].split(separator);\nmsg.columns = keys.join(\",\");\nline_skip++\nlines = lines.slice(line_skip)\n\nlines.forEach(line => {\n let obj = {};\n line.split(separator).forEach((value, index) => {\n try {\n value = JSON.parse(value.replace(/\\\\/g, \"\"));\n } catch (exceptionVar) {\n }\n obj[keys[index]] = value;\n })\n output.push(obj);\n})\nmsg.payload = output;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":250,"y":1060,"wires":[["2274ba66c3d4e1ca","7aeaa6275292cff7"]]},{"id":"2274ba66c3d4e1ca","type":"debug","z":"d1395164b4eec73e","name":"debug 2453","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":550,"y":1100,"wires":[]}]
let line_skip = 1;
const separator = ";";
const output = []
let lines = msg.payload.split("\n")
let keys = lines[line_skip].split(separator);
msg.columns = keys.join(",");
line_skip++
lines = lines.slice(line_skip)
lines.forEach(line => {
let obj = {};
line.split(separator).forEach((value, index) => {
try {
value = JSON.parse(value.replace(/\\/g, ""));
} catch (exceptionVar) {
}
obj[keys[index]] = value;
})
output.push(obj);
})
msg.payload = output;
return msg;
output
[
{
"#": "device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R01a52f67-554c-5791-8503-fcbee07f93d9",
"active": true,
"bidirPartnerId": null,
"codecFormat": "Audio",
"configPriority": "off",
"control": "off",
"custom": {},
"descriptor": {
"desc": "",
"label": ""
},
"extraAlertFilters": [],
"Factory label": "receiver_s06_a03",
"isIgmpSource": false,
"mainDstIp": null,
"mainDstMac": null,
"mainDstPort": null,
"mainDstVlan": null,
"mainSrcGateway": null,
"mainSrcIp": null,
"mainSrcMac": null,
"mainSrcNetmask": null,
"public": false,
"sdpSupport": true,
"sipsMode": "NONE",
"spareDstIp": null,
"spareDstMac": null,
"spareDstPort": null,
"spareDstVlan": null,
"spareSrcGateway": null,
"spareSrcIp": null,
"spareSrcMac": null,
"spareSrcNetmask": null,
"tags": [],
"useAsEndpoint": false
},
{
"#": "device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R02d8318e-62ea-5d74-8693-9d3e7024f560",
"active": true,
"bidirPartnerId": null,
"codecFormat": "Audio",
"configPriority": "off",
"control": "off",
"custom": {},
"descriptor": {
"desc": "blabla",
"label": ""
},
"extraAlertFilters": [],
"Factory label": "receiver_s05_a01",
"isIgmpSource": false,
"mainDstIp": null,
"mainDstMac": null,
"mainDstPort": null,
"mainDstVlan": null,
"mainSrcGateway": null,
"mainSrcIp": null,
"mainSrcMac": null,
"mainSrcNetmask": null,
"public": false,
"sdpSupport": true,
"sipsMode": "NONE",
"spareDstIp": null,
"spareDstMac": null,
"spareDstPort": null,
"spareDstVlan": null,
"spareSrcGateway": null,
"spareSrcIp": null,
"spareSrcMac": null,
"spareSrcNetmask": null,
"tags": [],
"useAsEndpoint": false
},
{
"#": "device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R030c78b8-e95c-5012-bfc8-bd7ef3188d16",
"active": true,
"bidirPartnerId": null,
"codecFormat": "Ancillary",
"configPriority": "off",
"control": "off",
"custom": {},
"descriptor": {
"desc": "",
"label": ""
},
"extraAlertFilters": [],
"Factory label": "receiver_s02_m00",
"isIgmpSource": false,
"mainDstIp": null,
"mainDstMac": null,
"mainDstPort": null,
"mainDstVlan": null,
"mainSrcGateway": null,
"mainSrcIp": null,
"mainSrcMac": null,
"mainSrcNetmask": null,
"public": false,
"sdpSupport": true,
"sipsMode": "NONE",
"spareDstIp": null,
"spareDstMac": null,
"spareDstPort": null,
"spareDstVlan": null,
"spareSrcGateway": null,
"spareSrcIp": null,
"spareSrcMac": null,
"spareSrcNetmask": null,
"tags": [],
"useAsEndpoint": false
},
{
"#": "device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R0528ad48-62b6-5a22-9267-8f7f6f1e77ec",
"active": true,
"bidirPartnerId": null,
"codecFormat": "Audio",
"configPriority": "off",
"control": "off",
"custom": {},
"descriptor": {
"desc": "",
"label": ""
},
"extraAlertFilters": [],
"Factory label": "receiver_s01_a01",
"isIgmpSource": false,
"mainDstIp": null,
"mainDstMac": null,
"mainDstPort": null,
"mainDstVlan": null,
"mainSrcGateway": null,
"mainSrcIp": null,
"mainSrcMac": null,
"mainSrcNetmask": null,
"public": false,
"sdpSupport": true,
"sipsMode": "NONE",
"spareDstIp": null,
"spareDstMac": null,
"spareDstPort": null,
"spareDstVlan": null,
"spareSrcGateway": null,
"spareSrcIp": null,
"spareSrcMac": null,
"spareSrcNetmask": null,
"tags": [],
"useAsEndpoint": false
},
{
"#": "device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R086b784a-d876-5db7-a2c9-6d41edb2f182",
"active": true,
"bidirPartnerId": null,
"codecFormat": "Audio",
"configPriority": "off",
"control": "off",
"custom": {},
"descriptor": {
"desc": "",
"label": ""
},
"extraAlertFilters": [],
"Factory label": "receiver_s02_a01",
"isIgmpSource": false,
"mainDstIp": null,
"mainDstMac": null,
"mainDstPort": null,
"mainDstVlan": null,
"mainSrcGateway": null,
"mainSrcIp": null,
"mainSrcMac": null,
"mainSrcNetmask": null,
"public": false,
"sdpSupport": true,
"sipsMode": "NONE",
"spareDstIp": null,
"spareDstMac": null,
"spareDstPort": null,
"spareDstVlan": null,
"spareSrcGateway": null,
"spareSrcIp": null,
"spareSrcMac": null,
"spareSrcNetmask": null,
"tags": [],
"useAsEndpoint": false
},
{
"#": "device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R0ad25e5f-ce89-508a-809d-3389e8626eba",
"active": true,
"bidirPartnerId": null,
"codecFormat": "Ancillary",
"configPriority": "off",
"control": "off",
"custom": {},
"descriptor": {
"desc": "",
"label": ""
},
"extraAlertFilters": [],
"Factory label": "receiver_s06_m00",
"isIgmpSource": false,
"mainDstIp": null,
"mainDstMac": null,
"mainDstPort": null,
"mainDstVlan": null,
"mainSrcGateway": null,
"mainSrcIp": null,
"mainSrcMac": null,
"mainSrcNetmask": null,
"public": false,
"sdpSupport": true,
"sipsMode": "NONE",
"spareDstIp": null,
"spareDstMac": null,
"spareDstPort": null,
"spareDstVlan": null,
"spareSrcGateway": null,
"spareSrcIp": null,
"spareSrcMac": null,
"spareSrcNetmask": null,
"tags": [],
"useAsEndpoint": false
},
{
"#": "device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R1ded5cf7-68f5-5476-8b4f-c3704736f1c8",
"active": true,
"bidirPartnerId": null,
"codecFormat": "Audio",
"configPriority": "off",
"control": "off",
"custom": {},
"descriptor": {
"desc": "",
"label": ""
},
"extraAlertFilters": [],
"Factory label": "receiver_s05_a02",
"isIgmpSource": false,
"mainDstIp": null,
"mainDstMac": null,
"mainDstPort": null,
"mainDstVlan": null,
"mainSrcGateway": null,
"mainSrcIp": null,
"mainSrcMac": null,
"mainSrcNetmask": null,
"public": false,
"sdpSupport": true,
"sipsMode": "NONE",
"spareDstIp": null,
"spareDstMac": null,
"spareDstPort": null,
"spareDstVlan": null,
"spareSrcGateway": null,
"spareSrcIp": null,
"spareSrcMac": null,
"spareSrcNetmask": null,
"tags": [],
"useAsEndpoint": false
},....
]