Problem with CSV import data parsing

Hi there !

I have a small problem with CSV data in Node RED.

The CSV imported includes some fields like :

;{};{"desc":"blabla","label":""};[];

When I import this and stores in a global Var, I get this :

image

On of course the same result when I output back the CSV from the Var...

I could tweak the workflow to get a proper result in the end, but it adds some (hopefully) un-needed work.

Is there an easy way to fix this ?

Thanks !

The snippet of data you posted shows no evidence of being comma seperated. Semicolons maybe.

This fragment seems to be a json object.

Where does the data come from - do you have control of the structure, or is there a specification to work with?

They all appear to be valid JSON
{ }
{"desc":"blabla","label":""}
[ ]
@JeromeVISUALS you should be able to run each through a JSON node or similar.
[edit] How are you importing it? I tried runing the string through a csv node but it through an error when using semi colon as separator.

msg : error
"TypeError: Cannot read properties of undefined (reading 'includes')"

Doesn't appear to like the null value before first semi colon, Looks like a bug in csv node?

Hi, indeed the content of the CSV imported ( on which I dont have any control) looks like all JSON compliant, and overall is trated as such by the CSV node, without needing any additional JSON parsing, as you can see on the gloabal variable directly from the CSV import node :

So I did not think about adding any kind of JSON parsing node, but I'll give it a try. I thought ( but might be wrong) that as the overall CSV content is parsed correctly, I should not need any kind of addional data parsing....

as a reminder, origin CSV extract matching the above screenshot :grinning:

device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R01a52f67-554c-5791-8503-fcbee07f93d9;true;null;Audio;off;off;{};{"desc":"","

Hi again, great to see you made a try, but I just posted a very small extract of the imported original CSV ...

Here you'll find the whole content :


#;Vertices of type codecVertex
#;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
device73.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
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R02d8318e-62ea-5d74-8693-9d3e7024f560;true;null;Audio;off;off;{};{"desc":"blabla","label":""};[];receiver_s05_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R030c78b8-e95c-5012-bfc8-bd7ef3188d16;true;null;Ancillary;off;off;{};{"desc":"","label":""};[];receiver_s02_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R0528ad48-62b6-5a22-9267-8f7f6f1e77ec;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s01_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R086b784a-d876-5db7-a2c9-6d41edb2f182;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s02_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R0ad25e5f-ce89-508a-809d-3389e8626eba;true;null;Ancillary;off;off;{};{"desc":"","label":""};[];receiver_s06_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R1ded5cf7-68f5-5476-8b4f-c3704736f1c8;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s05_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R213ec965-bba2-5f51-836c-25c677826737;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s06_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R26a7fd26-97ef-5d70-a2ab-a773c18f6656;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s02_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R2ee8ab84-34e3-5e23-bdf5-259389c374ac;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s03_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R34a4f06f-24f9-53db-84e3-76cf940a3d55;true;null;Ancillary;off;off;{};{"desc":"","label":""};[];receiver_s01_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R382b1265-1762-5d63-ae80-6f5d579027af;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s00_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R3fe65e4a-1064-5893-9b4c-f491df531f1b;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s04_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R428008a8-b3d1-5141-93ad-a26de04a84a3;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s00_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R459363e1-59d1-59de-998e-ecf26e094dfa;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s05_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R4af114ca-7f6c-51f8-8453-00f52e660a8c;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s03_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R4c0ff767-a10d-533b-910a-6467dfc2b910;true;null;Ancillary;off;off;{};{"desc":"","label":""};[];receiver_s03_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R5d44b581-eeb8-53cf-8a0f-b83bc0293248;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s05_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R617d9cfe-7243-5bd4-8795-33816a0cb5b7;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH03_RxV"};[];receiver_s02_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R62673eb6-d04b-5087-8427-1aaab95854e4;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s02_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R6368aa84-5f8b-5a30-97d4-93b521c0a50f;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s04_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R656f0fe6-8e8a-5317-a873-55b087bb28f7;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH08_RxV"};[];receiver_s07_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R675b0b23-2a38-547c-b6e6-1b177014c959;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s04_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R675ff029-4142-5ea5-90b9-66f9fc29b4ba;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH07_RxV"};[];receiver_s06_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R762da3b0-c5c5-565e-a79d-f4d1670a70a1;true;null;Ancillary;off;off;{};{"desc":"","label":""};[];receiver_s00_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R8c88a809-6cf7-5813-9929-4d97ec137ebe;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH01_RxV"};[];receiver_s00_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R925c1ce5-0701-512a-a508-9ee251044ae1;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s06_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.R97ffba7d-c3d0-5293-8327-103f58491cba;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s01_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Ra29abfc3-55db-5484-b33b-086a258e3777;true;null;Ancillary;off;off;{};{"desc":"","label":""};[];receiver_s07_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Raa4bae92-b1e8-5211-a1d0-2e7d15278ff8;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s00_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rb37ae371-381e-527f-abdd-f6774eb674a7;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH06_RxV"};[];receiver_s05_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rb4ce60fb-3579-5560-bb6a-a005a51bbabf;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s02_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rb601d550-582c-5a71-863b-5e7569286ce3;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s07_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rb7d8f5a2-4826-52ad-84b9-cdc01cca36fb;true;null;Ancillary;off;off;{};{"desc":"","label":""};[];receiver_s05_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rbb0364ea-7c54-5db8-be06-d00d49982153;true;null;Ancillary;off;off;{};{"desc":"","label":""};[];receiver_s04_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rbb3cebac-61b1-5836-9949-58dbe178d6e8;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s01_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rce83dbd8-4e7b-5d48-8518-8acc7e0e0908;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s01_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rd45cad3e-936a-5438-ace2-ad72953f68d2;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s07_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Re21a576a-d9c1-51aa-bce0-37ad009e9333;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s03_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Re3cfeabf-0904-58c1-87c1-86bf6ee22c42;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s06_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Re52eecc3-9a55-5025-bf15-a4867b665a34;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s04_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Re99a635f-efb1-5b01-b2e1-3e20b0f68a84;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s00_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Reb19198a-daed-5bb6-a932-b4661773e93f;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s03_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rec098c94-297b-5668-9da0-b623bc27bc25;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH04_RxV"};[];receiver_s03_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Redbd3558-dc22-5493-a873-521418cd6715;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH02_RxV"};[];receiver_s01_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rf2675616-9af3-5a75-870b-067d3b49ba0f;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s07_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rfea39e73-dd34-5936-85e1-01daac04e700;true;null;Audio;off;off;{};{"desc":"","label":""};[];receiver_s07_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Rfef03e54-f2e1-51ca-a50c-f3a0129b2c04;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH05_RxV"};[];receiver_s04_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S05a3647d-4bee-573a-9676-fe6418535423;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH08_RxV"};[];sender_s07_v00;false;null;null;null;null;null;null;null;null;false;true;SIPSAuto;null;null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S07f213e6-b49b-56d2-9533-8bd0938f78e8;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s01_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S0c7f8f75-836d-5269-9eb1-ae14b762acde;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s05_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S0f528a89-01cf-5d8d-921b-806f0457f622;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s03_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S12c673e8-1bf3-53c0-abf9-ee664dc548d9;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s00_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S143d961a-3651-580d-a612-c3ee2c6c20f8;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s01_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S14a325a9-c40f-5506-ac7a-72cdd79a8595;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s07_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S2f538923-8e39-5c07-b66e-76cef501fc15;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s02_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S301bcca1-3f7a-55b5-b45e-9e0f960cb7ed;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s03_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S33d2f8a7-4048-56ce-854d-84547814da2c;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s03_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S4014bf26-4a42-5813-9d4c-3960eb00d82b;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s05_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S445b8f10-d95d-5829-b465-52f253a0d371;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s02_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S472ca751-b0cc-5419-86af-e90423f2c4ce;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s06_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S4b4437d6-4ef8-5a87-a611-1b79d958c40f;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s01_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S4ef3e379-3623-57c1-816c-9f9b6b62bceb;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH06_TxV"};[];sender_s05_v00;false;{"poolId":"RTS-Video-PRI","type":"nPoolId"};null;null;null;null;null;null;null;false;true;NONE;{"poolId":"RTS-Video-SEC","type":"nPoolId"};null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S58f5106b-167b-586b-bccc-2adae243e155;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s07_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S5d66cea6-fc34-5399-b2c9-ce5522418c25;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s02_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S601b57f9-4224-5694-a578-d4afb33f782a;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s05_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S6904683c-f84e-5f75-8719-fb4106e43de4;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s04_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S69950367-3250-5964-a71f-8d13e5c31ebe;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s00_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S69d23332-9cd0-5f34-946c-5cfc112b40b5;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s01_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S6ad99eff-a789-5f7e-b6ba-fef830e82489;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s07_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S77e6d41e-589a-57e0-91b0-05368dfa4f9d;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s07_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S78f17c1d-1526-5db1-90e7-616d7f0ce2d0;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s05_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S7ed87f91-6f5a-5f01-95bb-99e1efb7798d;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s06_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S8dae3992-2695-5a26-8cba-cf283f8e9ca4;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s01_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S978f417f-86f9-56ae-a17c-9d068f42bb95;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s07_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.S99f11518-fbf8-5a15-a880-36a198b56773;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH02_TxV"};[];sender_s01_v00;false;{"poolId":"RTS-Video-PRI","type":"nPoolId"};null;null;null;null;null;null;null;false;true;NONE;{"poolId":"RTS-Video-SEC","type":"nPoolId"};null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sa59c2b22-cb0b-5303-9f73-3aff550e54b8;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s04_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sa69edc5b-109e-54af-9534-c39e8cefea70;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s00_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sb0004110-706e-5fbb-bcff-7083bc961877;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s06_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sb03d1d2a-9daf-54c2-815a-456813621f0a;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH04_TxV"};[];sender_s03_v00;false;{"poolId":"RTS-Video-PRI","type":"nPoolId"};null;null;null;null;null;null;null;false;true;NONE;{"poolId":"RTS-Video-SEC","type":"nPoolId"};null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sb139d62b-d9db-5dbe-9296-e362486dc626;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s03_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sbcfbf113-7868-57f1-ae4c-48856077edbb;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH05_TxV"};[];sender_s04_v00;false;{"poolId":"RTS-Video-PRI","type":"nPoolId"};null;null;null;null;null;null;null;false;true;NONE;{"poolId":"RTS-Video-SEC","type":"nPoolId"};null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sbd45622a-ca50-5127-b80e-510f68ca4639;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s05_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sc0744533-ab63-5e03-92b6-ee1d112f132f;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH01_TxV"};[];sender_s00_v00;false;{"poolId":"RTS-Video-PRI","type":"nPoolId"};null;null;null;null;null;null;null;false;true;NONE;{"poolId":"RTS-Video-SEC","type":"nPoolId"};null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sccaea507-9d45-5f3d-a3b6-10d0eaeea8c2;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s03_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sd3d24f83-9c65-578d-92ff-42789b63b97b;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s06_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sd8e550b2-26b4-5367-b284-77a8edf2f1cd;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s04_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sdad5ed2c-1dd8-530a-ae42-990d9f453a01;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s04_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sdc4d27a2-bddf-50f2-8b12-502c5ef94ed0;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s06_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sddb6b1ec-219d-549b-bd33-d01468e4b8c1;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s02_a01;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Se4ad1409-540d-5657-a598-911d9d003bea;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH07_TxV"};[];sender_s06_v00;false;{"poolId":"RTS-Video-PRI","type":"nPoolId"};null;null;null;null;null;null;null;false;true;NONE;{"poolId":"RTS-Video-SEC","type":"nPoolId"};null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Se74efcd7-7ca9-5452-98ce-208c57db8c55;true;null;Video;off;full;{};{"desc":"","label":"VGW01-01C01_CH03_TxV"};[];sender_s02_v00;false;{"poolId":"RTS-Video-PRI","type":"nPoolId"};null;null;null;null;null;null;null;false;true;NONE;{"poolId":"RTS-Video-SEC","type":"nPoolId"};null;null;null;null;null;null;null;["Vid_1080i50","Vid_1080p50","Vid_2160p25","Vid_2160p50","#SCORPION","#REGIE2.2"];true
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sf265ab29-0d9f-5a66-9776-6de7ad5e501f;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s02_a00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sf34dcffe-f4ca-5308-b130-b48259cb4962;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s00_a02;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sf51396c3-0b8a-5581-8e27-e6a571ead202;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s00_a03;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false
device73.484735f6-a1ea-596e-8282-0cd1108e6be2.Sf996d7d3-fc81-519e-afde-4e3b6bc4cd46;true;null;Video;off;off;{};{"desc":"","label":""};[];sender_s04_m00;false;null;null;null;null;null;null;null;null;false;true;NONE;null;null;null;null;null;null;null;null;[];false

No, the csv node is stripping the quotes as they are used to encapsulate strings with commas. Thus turning the compliant JSON strings in to uncompliant JSON

Ok great. so adding JSON node into the loop should make it right ?

No, As the csv node strips the quotes I think you would be best creating a function to split your csv, and another to convert it back.

That is not COMMA separated but SEMI-COLON separated. I assume that you have the csv node appropriately set.

As for parsing the contained JSON, you will have to set the CSV node to output individual records and I believe you will have to manually parse each field separately for each output msg from the input. You could do that with a series of json nodes after the csv node or, more succinctly, using a function node.

Sure, the CSV node is set with SEMI-COLON , so I get all the Array properly set with all objects.

I just did a test with a JSON in between but , as expected, no change.

I'll make some tests to figure out the best way and come back to you.

Ok, got it in a cleaner way, using a function node like that :

var inputCSV = msg.payload;

    for (let i = 0; i < inputCSV.length; i++) {

        var OrgDescriptor = inputCSV[i].descriptor;

        OrgDescriptor = OrgDescriptor.replace("{", "")
        OrgDescriptor = OrgDescriptor.replace("}", "")
        OrgDescriptor = OrgDescriptor.split(",");

        var newdescriptor = {"desc": OrgDescriptor[0].replace("desc:",""), "label":OrgDescriptor[1].replace("label","")}
        inputCSV[i].descriptor = newdescriptor
    }

msg.payload = inputCSV;

Result :

image

I'll go thtough all the code now to adapt to this object instead of string, and then see how it behaves on the export side.

Thanks for your tips !

Jerome

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
    },....
]

Very interesting, I'll check that ! looks like the way to Pure NodeJS coding :slight_smile:

Actually I found easier code to handle that problematic value from csv node, instead of the one I posted earlier :

var inputCSV = msg.payload;

    for (let i = 0; i < inputCSV.length; i++) {

        inputCSV[i].descriptor = JSON.parse(inputCSV[i].descriptor);
    }

msg.payload = inputCSV;
return msg;

1 Like

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.