# TCP Data to csv file

**URL:** <https://discourse.nodered.org/t/tcp-data-to-csv-file/30411>\
**Category:** General\
**Created:** [20 July 2020 17:58 UTC](https://discourse.nodered.org/t/tcp-data-to-csv-file/30411 "2020-07-20T17:58:15Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![valmik](https://avatars.discourse-cdn.com/v4/letter/v/76d3ee/32.png) [@valmik](https://discourse.nodered.org/u/valmik)\
**Post date:** [20 July 2020 17:58 UTC](https://discourse.nodered.org/t/tcp-data-to-csv-file/30411/1 "2020-07-20T17:58:15Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [18 September 2020 17:58 UTC](https://discourse.nodered.org/t/tcp-data-to-csv-file/30411/2 "2020-09-18T17:58:20Z")

</div>

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