TCP Data to csv file

General
1

Hello ,
From IoT sensor I am getting data over GPRS ( TCP ) format and able to create csv file by using TCP,CSV,SPLIT & FILE node I am getting below format in csv file
$SLU355000082004871
06
430
200720162523
01
null
null
null
null
null
000002
3400
59844
24.006
03.457
null
0
null
null
CAEaBsKNXKT5KA==
Location
null
0
null
null
CAIaBvoPye4ytg==
D14DBE681992
1
30.7
72.5
CAMaBtFNvmgZkjhJSNAXKNUFIOYEWABoAHACeACAAQCIAQA=
null
0
null
null
CAQaBsbl7doEdw==
But our database understand different format mainly Columnname : value in above format I got value only not Column name I am beginner for Node-Red can you please support to include Column Name in below format
UID:$SLU355000082004871
CMD:06
RNO:430
EDT:200720162523
EID:01
PDT:null
LAT:null
LONG:null
SPDK:null
HEAD:null
ODO:000002
3400
59844
24.006
03.457
null
0
null
null
CAEaBsKNXKT5KA==
Location
null
0
null
null
CAIaBvoPye4ytg==
D14DBE681992
1
30.7
72.5
CAMaBtFNvmgZkjhJSNAXKNUFIOYEWABoAHACeACAAQCIAQA=
null
0
null
null
CAQaBsbl7doEdw==
please let me know how i can add this column name in file thanks in advance for support

2

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