json解析

收藏

本帖最后由戈少武于 2024-8-28 12:26 编辑

{

words_result: [
- {
  - result: {
    - invoice_code: [
      - {
        word: "137162150132"
        
        }
      ],
    - ServiceType: [
      - {
        word: "交通"
        
        }
      ],
    - invoice_rate: [
      - {
        word: "伍拾元"
        
        }
      ],
    - invoice_rate_in_figure: [
      - {
        word: "50.00"
        
        }
      ],
    - invoice_type: [
      - {
        word: "山东通用定额**"
        
        }
      ],
    - City: [
      - {
        word: "滨州市"
        
        }
      ],
    - invoice_number: [
      - {
        word: "00642452"
        
        }
      ],
    - invoice_rate_in_word: [
      - {
        word: "伍拾元"
        
        }
      ],
    - Province: [
      - {
        word: "山东省"
        
        }
      ],
    - Location: [
      - {
        word: "山东省滨州市"
        
        }
      ]
    },
  - top: 82,
  - left: 87,
  - probability: 0.9236758351,
  - width: 506,
  - type: "quota_invoice",
  - height: 748
  },
- {
  - result: {
    - Entrance: [
      - {
        word: "山东无棣站"
        
        }
      ],
    - OutTime: [
      - {
        word: "134022"
        
        }
      ],
    - ServiceType: [
      - {
        word: "交通"
        
        }
      ],
    - InvoiceCode: [
      - {
        word: "113002225011"
        
        }
      ],
    - OutDate: [
      - {
        word: "2024-05-14"
        
        }
      ],
    - City: [
      - {
        word: ""
        
        }
      ],
    - TotalAmount: [
      - {
        word: "30"
        
        }
      ],
    - Province: [
      - {
        word: "河北省"
        
        }
      ],
    - Exit: [
      - {
        word: "河北沧州开发"
        
        }
      ],
    - InvoiceNum: [
      - {
        word: "79740172"
        
        }
      ]
    },
  - top: 60,
  - left: 646,
  - probability: 0.985475719,
  - width: 679,
  - type: "toll_invoice",
  - height: 561
  },
- {
  - result: {
    - PickupTime: [
      - {
        word: "22:20"
        
        }
      ],
    - DropoffTime: [
      - {
        word: "22:22"
        
        }
      ],
    - Time: [
      - {
        word: "22:20-22:22"
        
        }
      ],
    - City: [
      - {
        word: ""
        
        }
      ],
    - FuelOilSurcharge: [
      - {
        word: "0.00"
        
        }
      ],
    - Date: [
      - {
        word: "2024-07-13"
        
        }
      ],
    - Province: [
      - {
        word: "天津"
        
        }
      ],
    - CallServiceSurcharge: [
      - {
        word: "0.00"
        
        }
      ],
    - Fare: [
      - {
        word: "13.00"
        
        }
      ],
    - TotalFare: [
      - {
        word: "13.00"
        
        }
      ],
    - TaxiNum: [
      - {
        word: "02195"
        
        }
      ],
    - ServiceType: [
      - {
        word: "交通"
        
        }
      ],
    - PricePerkm: [
      - {
        word: "2.50"
        
        }
      ],
    - InvoiceCode: [
      - {
        word: "112002060221"
        
        }
      ],
    - Distance: [
      - {
        word: "0.8"
        
        }
      ],
    - InvoiceNum: [
      - {
        word: "32353536"
        
        }
      ],
    - Location: [
      - {
        word: "天津"
        
        }
      ]
    },
  - top: 851,
  - left: 235,
  - probability: 0.9593805671,
  - width: 308,
  - type: "taxi_receipt",
  - height: 1034
  },
- {
  - result: {
    - Entrance: [
      - {
        word: "山东滨港站"
        
        }
      ],
    - OutTime: [
      - {
        word: "143444"
        
        }
      ],
    - ServiceType: [
      - {
        word: "交通"
        
        }
      ],
    - InvoiceCode: [
      - {
        word: "113002225011"
        
        }
      ],
    - OutDate: [
      - {
        word: "2024-07-16"
        
        }
      ],
    - City: [
      - {
        word: ""
        
        }
      ],
    - TotalAmount: [
      - {
        word: "58"
        
        }
      ],
    - Province: [
      - {
        word: "河北省"
        
        }
      ],
    - Exit: [
      - {
        word: "口河北沧州开发"
        
        }
      ],
    - InvoiceNum: [
      - {
        word: "80803145"
        
        }
      ]
    },
  - top: 621,
  - left: 644,
  - probability: 0.9877070189,
  - width: 676,
  - type: "toll_invoice",
  - height: 564
  },
- {
  - result: {
    - invoice_code: [
      - {
        word: "137162150132"
        
        }
      ],
    - ServiceType: [
      - {
        word: "交通"
        
        }
      ],
    - invoice_rate: [
      - {
        word: "伍拾元"
        
        }
      ],
    - invoice_rate_in_figure: [
      - {
        word: "50.00"
        
        }
      ],
    - invoice_type: [
      - {
        word: "山东通用定额**"
        
        }
      ],
    - City: [
      - {
        word: "滨州市"
        
        }
      ],
    - invoice_number: [
      - {
        word: "00642451"
        
        }
      ],
    - invoice_rate_in_word: [
      - {
        word: "伍拾元"
        
        }
      ],
    - Province: [
      - {
        word: "山东省"
        
        }
      ],
    - Location: [
      - {
        word: "山东省滨州市"
        
        }
      ]
    },
  - top: 1202,
  - left: 789,
  - probability: 0.9431347251,
  - width: 520,
  - type: "quota_invoice",
  - height: 713
  }
],
words_result_num: 5,
log_id: 1828628705811822300

}

戈少武 · 戈少武

我有上面一个json，由于每个result下面的节点名称不一样，现在需要把它转化为表格里去，这个怎么解决呢？我想逻辑是根据每个result下的type值进行判断，然后根据判断结果，将result下的字段值放到不同的表格里。但具体怎么实现呢？

Joe.xu · Joe.xu

楼主每次拿到的这个Json结构都是固定的吗，如果要解析的话，
需要固定的结构才好解析，不然找不到对应的属性就会报异常
另外看您这个结构，前面还会有数字，这个拷贝造成的是吧，真实的应该没有吧

一般来说这种可以这样干，解析这个数据，拼接处您需要的数据，如果要放在表格中，都需要数组的形式
然后将这些数组放在对应表格中展示
我们有专门的插件可以供解析和创建数据结构
对象与集合操作工具 - 葡萄城市场 (grapecity.com.cn)
对象操作工具集合 - 葡萄城市场 (grapecity.com.cn)

戈少武 · 戈少武

前面的数字，真实的json是没有的。

戈少武 · 戈少武

上面这个结构里，第1，2是固定的，3是不固定的。

戈少武 · 戈少武

3的属性是根据2下面的这个type的值而变化的。

Joe.xu · Joe.xu

像您说的这个需求，其实本质上就是把拿到的数据拆开重组成我们需要的结构，
拆开的过程就是正常数据解析的过程，这是要数据结构是已知的，通过Type判断得出下层数据结构也行。
解析完就是利用上面的插件来重构自己需要的数据结构

		自动登录	找回密码
密码			立即注册

[已处理] json解析

6 个回复

本帖子中包含更多资源

本帖子中包含更多资源

本帖子中包含更多资源

活字格认证

活字格高级认证

微信认证勋章

讲师达人

悬赏达人

圣诞拼拼乐