C/C++教程
Node-RED中将CSV数据写入txt文件并从文件中读取解析数据
本文主要是介绍Node-RED中将CSV数据写入txt文件并从文件中读取解析数据，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！
场景
Node-RED简介与Windows上安装、启动和运行示例：
https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/121884766
Node-RED怎样导出导入流程为json文件：
https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/124130985
CSV的内容是使用纯文字方式表示的表格资料，第一行是表格的标题，每一列用,隔开。
例如：
Name,height,weight
Joe,170,70
Mary,160,49
怎样将数据存储到txt文件中，需要时从文件中读取并解析获取数据。
注：
博客：
https://blog.csdn.net/badao_liumang_qizhi
关注公众号
霸道的程序猿
获取编程相关电子书、教程推送与免费下载。
实现
1、页面布局
2、template节点，输入csv资料
3、file节点，将csv资料用utf-8编码写入D://file.txt
4、file in节点，读取file.txt，输出utf-8的一个字符
5、csv节点，剖析csv资料，输入列名，分隔符是逗号，因为第一列是标题列，所以在输入时忽略第一行
输出时选择每行一条信息
6、解析效果
7、json数据
[
{
"id": "f4a4d8eab7935bc8",
"type": "tab",
"label": "流程 3",
"disabled": false,
"info": "",
"env": []
},
{
"id": "c428312d1f6165d1",
"type": "mqtt-broker",
"name": "mqtt",
"broker": "127.0.0.1",
"port": "1883",
"clientid": "",
"autoConnect": true,
"usetls": false,
"protocolVersion": "4",
"keepalive": "60",
"cleansession": true,
"birthTopic": "",
"birthQos": "0",
"birthPayload": "",
"birthMsg": {},
"closeTopic": "",
"closeQos": "0",
"closePayload": "",
"closeMsg": {},
"willTopic": "",
"willQos": "0",
"willPayload": "",
"willMsg": {},
"sessionExpiry": ""
},
{
"id": "51eee50b4ec9422f",
"type": "ui_group",
"name": "dashboardDemo",
"tab": "29ae4c620f43ee0d",
"order": 1,
"disp": true,
"width": "6",
"collapse": false,
"className": ""
},
{
"id": "29ae4c620f43ee0d",
"type": "ui_tab",
"name": "Home",
"icon": "dashboard",
"disabled": false,
"hidden": false
},
{
"id": "a506c767a5c1edbd",
"type": "ui_base",
"theme": {
"name": "theme-light",
"lightTheme": {
"default": "#0094CE",
"baseColor": "#0094CE",
"baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif",
"edited": true,
"reset": false
},
"darkTheme": {
"default": "#097479",
"baseColor": "#097479",
"baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif",
"edited": false
},
"customTheme": {
"name": "Untitled Theme 1",
"default": "#4B7930",
"baseColor": "#4B7930",
"baseFont": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"
},
"themeState": {
"base-color": {
"default": "#0094CE",
"value": "#0094CE",
"edited": false
},
"page-titlebar-backgroundColor": {
"value": "#0094CE",
"edited": false
},
"page-backgroundColor": {
"value": "#fafafa",
"edited": false
},
"page-sidebar-backgroundColor": {
"value": "#ffffff",
"edited": false
},
"group-textColor": {
"value": "#1bbfff",
"edited": false
},
"group-borderColor": {
"value": "#ffffff",
"edited": false
},
"group-backgroundColor": {
"value": "#ffffff",
"edited": false
},
"widget-textColor": {
"value": "#111111",
"edited": false
},
"widget-backgroundColor": {
"value": "#0094ce",
"edited": false
},
"widget-borderColor": {
"value": "#ffffff",
"edited": false
},
"base-font": {
"value": "-apple-system,BlinkMacSystemFont,Segoe UI,Roboto,Oxygen-Sans,Ubuntu,Cantarell,Helvetica Neue,sans-serif"
}
},
"angularTheme": {
"primary": "indigo",
"accents": "blue",
"warn": "red",
"background": "grey",
"palette": "light"
}
},
"site": {
"name": "Node-RED Dashboard",
"hideToolbar": "false",
"allowSwipe": "false",
"lockMenu": "false",
"allowTempTheme": "true",
"dateFormat": "DD/MM/YYYY",
"sizes": {
"sx": 48,
"sy": 48,
"gx": 6,
"gy": 6,
"cx": 6,
"cy": 6,
"px": 0,
"py": 0
}
}
},
{
"id": "248cbbb0.18e794",
"type": "ui_group",
"name": "MyGroup",
"tab": "3f79c420.cfc1bc",
"order": 1,
"disp": true,
"width": "6",
"collapse": false
},
{
"id": "3f79c420.cfc1bc",
"type": "ui_tab",
"name": "Home",
"icon": "dashboard",
"disabled": false,
"hidden": false
},
{
"id": "a0954be5.a7f7e8",
"type": "ui_group",
"name": "MyInput",
"tab": "3f79c420.cfc1bc",
"order": 2,
"disp": true,
"width": "6",
"collapse": false
},
{
"id": "508bd6f8398ab80f",
"type": "ui_group",
"name": "OpenWeatherMap",
"tab": "3f79c420.cfc1bc",
"order": 3,
"disp": true,
"width": "6",
"collapse": false
},
{
"id": "8824dea1.83e31",
"type": "websocket-client",
"path": "ws://localhost:9898/",
"tls": "",
"wholemsg": "false"
},
{
"id": "f9c23ff5.026e",
"type": "file",
"z": "f4a4d8eab7935bc8",
"name": "",
"filename": "D://file.txt",
"appendNewline": true,
"createDir": false,
"overwriteFile": "true",
"encoding": "utf8",
"x": 480,
"y": 180,
"wires": [
[]
]
},
{
"id": "2ebfe992.fdc746",
"type": "inject",
"z": "f4a4d8eab7935bc8",
"name": "",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 190,
"y": 240,
"wires": [
[
"cfaafb8.012a108"
]
]
},
{
"id": "cfaafb8.012a108",
"type": "file in",
"z": "f4a4d8eab7935bc8",
"name": "",
"filename": "D://file.txt",
"format": "utf8",
"chunk": false,
"sendError": false,
"encoding": "utf8",
"allProps": false,
"x": 340,
"y": 240,
"wires": [
[
"ee4f2b44.0fc328"
]
]
},
{
"id": "32435220.d9c6ee",
"type": "debug",
"z": "f4a4d8eab7935bc8",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload.weight",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 680,
"y": 280,
"wires": []
},
{
"id": "ee4f2b44.0fc328",
"type": "csv",
"z": "f4a4d8eab7935bc8",
"name": "",
"sep": ",",
"hdrin": "",
"hdrout": "none",
"multi": "one",
"ret": "\\n",
"temp": "name,height,weight",
"skip": "1",
"strings": true,
"include_empty_strings": "",
"include_null_values": "",
"x": 470,
"y": 240,
"wires": [
[
"f250620f.1071d",
"d9c16f6a.a9d4b",
"32435220.d9c6ee"
]
]
},
{
"id": "f250620f.1071d",
"type": "debug",
"z": "f4a4d8eab7935bc8",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload.name",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 670,
"y": 200,
"wires": []
},
{
"id": "d9c16f6a.a9d4b",
"type": "debug",
"z": "f4a4d8eab7935bc8",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload.height",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 670,
"y": 240,
"wires": []
},
{
"id": "277f6cb6.89e434",
"type": "template",
"z": "f4a4d8eab7935bc8",
"name": "",
"field": "payload",
"fieldType": "msg",
"format": "handlebars",
"syntax": "mustache",
"template": "Name,height,weight\nJoe,170,70\nMary,160,49",
"output": "str",
"x": 330,
"y": 180,
"wires": [
[
"f9c23ff5.026e"
]
]
},
{
"id": "f22a93b5.26844",
"type": "inject",
"z": "f4a4d8eab7935bc8",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payloadType": "date",
"x": 190,
"y": 180,
"wires": [
[
"277f6cb6.89e434"
]
]
}
]
这篇关于Node-RED中将CSV数据写入txt文件并从文件中读取解析数据的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
您可能喜欢
-
Fetch / Axios学习：入门教程与实战指南11-14
-
Typescript 类型课程入门教程11-14
-
Fetch / Axios课程：初学者必看的网络请求教程11-14
-
Styled-components课程：初学者指南11-14
-
pre-commit 自动化测试课程：入门教程与实践指南11-13
-
什么是AIGC？如何使用AIGC技术辅助办公?11-13
-
Slicm 框架怎么进行用户认证？-icode9专业技术文章分享11-13
-
在查询时将 map_coord 列的值转换为字符串有哪些方法？-icode9专业技术文章分享11-13
-
如何将微信地区改成自定义文案？-icode9专业技术文章分享11-13
-
DNS 缓存存在问题有哪些症状和解决方法？-icode9专业技术文章分享11-13
-
HTTP 状态码（405）-Method Not Allowed是什么意思？-icode9专业技术文章分享11-13
-
HTTP 状态码（500）-Internal Server Error是什么意思？-icode9专业技术文章分享11-13
-
在 Element UI 中无法修改 $confirm 的取消按钮文字是什么原因？-icode9专业技术文章分享11-13
-
unity XR是什么？-icode9专业技术文章分享11-13
-
伴随矩阵是什么？-icode9专业技术文章分享11-13
栏目导航
