[{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"09001","certificateCode":"5201027010012008603","certificateFirstIssueDate":"2013-07-06","certificateIssueDate":"2014-01-07","certificateExpireDate":"2019-07-05","licenseIssueOrganCode":"52010000","licenseIssueOrganName":"贵阳市道路运输管理局","issueOrganLocCode":"520100","certificateState":"2","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"03001","certificateCode":"5224271010012002627","certificateFirstIssueDate":"2014-05-07","certificateIssueDate":"2011-01-02","certificateExpireDate":"2012-03-01","licenseIssueOrganCode":"52052600","licenseIssueOrganName":"威宁自治县道路运输管理局","issueOrganLocCode":"520526","certificateState":"2","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"02001","certificateCode":"5224270020011001946","certificateFirstIssueDate":"2014-05-07","certificateIssueDate":"2014-05-11","certificateExpireDate":"2020-05-10","licenseIssueOrganCode":"52052600","licenseIssueOrganName":"威宁自治县道路运输管理局","issueOrganLocCode":"520526","certificateState":"1","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"09001","certificateCode":"5224011981020XX979","certificateFirstIssueDate":"2014-09-11","certificateIssueDate":"2014-09-11","certificateExpireDate":"2020-09-10","licenseIssueOrganCode":"52062700","licenseIssueOrganName":"沿河县道路运输局","issueOrganLocCode":"520627","certificateState":"1","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"01001","certificateCode":"5224270010011001945","certificateFirstIssueDate":"2014-05-07","certificateIssueDate":"2011-01-02","certificateExpireDate":"2012-03-01","licenseIssueOrganCode":"52052600","licenseIssueOrganName":"威宁自治县道路运输管理局","issueOrganLocCode":"520526","certificateState":"2","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"02001","certificateCode":"5202010020201000001","certificateFirstIssueDate":"2009-01-01","certificateIssueDate":"2015-06-27","certificateExpireDate":"2021-06-26","licenseIssueOrganCode":"52020000","licenseIssueOrganName":"六盘水市道路运输局","issueOrganLocCode":"520200","certificateState":"1","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"04002","certificateCode":"5224012020112001317","certificateFirstIssueDate":"2015-11-13","certificateIssueDate":"2015-11-13","certificateExpireDate":"2021-11-12","licenseIssueOrganCode":"52050000","licenseIssueOrganName":"毕节市道路运输局","issueOrganLocCode":"520500","certificateState":"1","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"01001","certificateCode":"5224010010014000001","certificateFirstIssueDate":"2014-06-12","certificateIssueDate":"2014-08-13","certificateExpireDate":"2020-08-12","licenseIssueOrganCode":"52050000","licenseIssueOrganName":"毕节市道路运输局","issueOrganLocCode":"520500","certificateState":"1","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"01001","certificateCode":"5227010010211000003","certificateFirstIssueDate":"2014-07-04","certificateIssueDate":"2014-07-18","certificateExpireDate":"2020-07-17","licenseIssueOrganCode":"52270000","licenseIssueOrganName":"黔南州道路运输管理局","issueOrganLocCode":"522700","certificateState":"1","certificateType":"1"},{"provinceCode":"520000","staffName":"张山","sex":"1","idType":"1","idCard":"5224011981020XX979","address":"贵州省","domicileCode":"522401","operTime":"2018-07-31","serialNo":"GZSWNX52000052050000000000061695","workTypeCode":"02001","certificateCode":"5226010020401000002","certificateFirstIssueDate":"2007-01-01","certificateIssueDate":"2007-01-01","certificateExpireDate":"2013-01-01","licenseIssueOrganCode":"52260000","licenseIssueOrganName":"黔东南州交通运输局","issueOrganLocCode":"522600","certificateState":"2","certificateType":"1"}]

Fill out the above for text content, how to split into datawindow window, the window header for provinceCode, staffName certificateType...

CodePudding user response:

https://download.csdn.net/download/ganzhenyu/16166897

Dw import and export json,
Demo there are for the building data processing, after open the program to find & lt; CSDN test & gt; button, see the inside of the code