• kettle中Get Data from XML , Jason Input , 文本文件输入 使用示例


    1、Get Data from XML

    xml文件内容:

    <head>
    <img id="1">菜||焦溜丸子||2013-03-28/image/0/0001-thumb.jpg</img>
    <img id="2">环境||门面||2013-03-28/image/0/0002-thumb.jpg</img>
    <img id="3">环境||门面||2013-03-28/image/0/0003-thumb.jpg</img>
    </head>

    设置及结果:

    2、Jason Input

    {"store": {      "book": [ 
          { "category": "reference",
            "author": "Nigel Rees",
            "title": "Sayings of the Century",
            "price": 8.95
          },
          { "category": "fiction",
            "author": "Evelyn Waugh",
            "title": "Sword of Honour",
            "price": 12.99
          },
          { "category": "fiction",
            "author": "Herman Melville",
            "title": "Moby Dick",
            "isbn": "0-553-21311-3",
            "price": 8.99
          },
          { "category": "fiction",
            "author": "J. R. R. Tolkien",
            "title": "The Lord of the Rings",
            "isbn": "0-395-19395-8",
            "price": 22.99
          }
          { "category": "fiction",
            "author": "Samatar",
            "title": "La belle vie",
            "isbn": "0-395-19395-8",
            "price": 24.99
          }
        ],
        "bicycle": {
          "color": "red",
          "price": 19.95
        }
      }
    }

    3、文本文件输入(price字段)

    name;posx;posy;url_addr;visited;price
    天天周末(黄浦店)       ;121.5;31.2;http://www.dianping.com/shop/5193999;1,084,934;$10.2
    唐人风尚美容美发沙龙      ;116.2;39.9;http://www.dianping.com/shop/5407383;888,984;$20.2
    伊姿美甲(八佰伴店)      ;121.5;31.2;http://www.dianping.com/shop/5397997;1,047,051;$10.5
    青浦区实验小学         ;121.1;31.1;http://www.dianping.com/shop/4127946;1,351,421;$13.2
    千喜国际美容美发(世纪城店)  ;116.3;40;http://www.dianping.com/shop/4564623;873,159;$12.3
    曼清瑜伽理疗馆         ;106.5;29.6;http://www.dianping.com/shop/5718907;1,410,166;$11.4
    西海歌厅            ;116.4;39.9;http://www.dianping.com/shop/2101444;823,716;$12.6
    弥奇博士美容排毒养生会所    ;116.3;39.9;http://www.dianping.com/shop/4038553;889,330;$16.4
    新发展古华山庄酒店       ;121.5;30.9;http://www.dianping.com/shop/8688480;1,077,595;$11.2
    世茂时尚欢乐影城        ;106.5;29.6;http://www.dianping.com/shop/5636995;1,409,593;$15.8

  • 相关阅读:
    CentOS 7 安装 MariaDB
    yum工具使用 -- 配置自定义yum源
    CentOS 7 安装 redis
    CentOS 7 安装Python3 + 虚拟环境 + django
    Linux 安装 Python3.6.5
    CentOS 7 安装Python3 虚拟环境
    oracle数据库分页原理
    POI工具类
    IoDH单例模式
    为什么使用单例模式【转】
  • 原文地址:https://www.cnblogs.com/melodyluo/p/3374280.html
Copyright © 2020-2023  润新知