• NodeRED中将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"
                ]
            ]
        }
    ] 
  • 相关阅读:
    Java 并发专题 :FutureTask 实现预加载数据 在线看电子书、浏览器浏览网页等
    Excel里的单元格提行
    Ubuntu各版本的历史发行界面
    CentOS常用命令、快照、克隆大揭秘
    虚拟网络编辑器的知识和出现的一些问题(没有VMnet0或VMnet8)
    CentOS图形界面下如何安装Eclipse和使用maven
    Hadoop MapReduce编程 API入门系列之mr编程快捷键活用技巧详解(四)
    Hadoop MapReduce概念学习系列之mr程序详谈(二十三)
    Hadoop MapReduce概念学习系列之mr的Shuffle(二十二)
    Hadoop MapReduce概念学习系列之JobTracker、ResourceManager、Task Tracker、NodeManager(二十一)
  • 原文地址:https://www.cnblogs.com/badaoliumangqizhi/p/16150656.html
Copyright © 2020-2023  润新知