多行字符串数据输出json格式

const data = `Micronesia, Fed. Sts. 23.6 23.6 23.6 23.6 23.6 23.6 23.6 23.6 23.6 23.6 23.6 23.6 23.6

Cuba 6.4 6.1 7.3 9.2 13.0 13.0 13.0 13.0 13.0 13.0 13.0 13.0 13.0

Solomon Islands 4.1 3.8 4.3 5.4 9.9 9.9 9.9 9.9 9.9 9.9 9.9 9.9 9.9

Botswana 4.0 4.3 6.7 9.3 9.5 9.5 9.5 9.5 9.5 9.5 9.5 9.5 9.5

Uzbekistan 9.3 9.3 9.4 9.4 9.4 9.4 9.4 9.4 9.4 9.4 9.4 9.4 9.4

Puerto Rico 7.3 8.5 8.8 9.0 9.1 9.1 9.2 9.2 8.6 8.6 8.6 8.6 8.6

Iceland 4.1 4.1 5.7 7.0 8.1 7.7 8.2 7.4 7.6 7.5 7.4 7.4 7.4

Djibouti 3.2 3.2 9.3 7.4 7.4 7.4 7.4 7.4 7.4 7.4 7.4 7.4 7.4

New Zealand 3.7 6.6 6.8 6.6 7.0 7.0 7.4 7.4 7.4 7.4 7.4 7.4 7.4

Sweden 6.2 5.0 6.8 6.5 6.1 6.0 7.1 7.2 7.1 7.1 7.2 7.2 7.2

Costa Rica 5.0 4.3 4.8 4.2 6.4 6.6 6.9 7.1 7.1 7.1 7.1 7.4 7.2

Saudi Arabia 2.6 5.7 7.2 7.2 7.2 7.2 7.2 7.2 7.2 7.2 7.2 7.2 7.2

Papua New Guinea 6.3 6.9 6.9 6.9 6.9 6.9 6.9 6.9 6.9 6.9 6.9 6.9 6.9

Denmark 4.6 6.7 7.6 7.7 7.9 8.1 6.4 7.7 6.9 6.9 6.9 6.9 6.9

Eswatini 3.0 4.5 5.2 6.6 8.5 9.2 8.4 7.6 6.8 6.8 6.8 6.8 6.8

Bhutan 2.4 2.4 4.4 4.3 3.1 3.4 4.2 5.1 5.9 6.8 6.8 6.8 6.8

Norway 5.0 5.6 5.8 6.3 6.1 5.9 6.8 6.6 6.6 6.3 6.7 6.7 6.7

Venezuela, RB 3.7 2.6 4.1 3.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5

Marshall Islands 6.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5 6.5

Oman 3.2 2.7 3.7 3.3 4.6 4.6 4.6 4.6 4.7 4.9 5.0 6.5 6.5

Belize 4.2 4.5 5.1 5.3 6.5 6.7 6.5 6.4 6.4 6.4 6.4 6.4 6.4

Honduras 2.9 4.0 3.9 4.8 5.8 6.0 6.1 6.3 6.3 6.3 6.3 6.3 6.3

Finland 4.9 5.2 5.4 5.6 6.1 6.0 6.8 6.7 6.6 6.4 6.3 6.3 6.3

Cyprus 4.0 3.1 5.0 5.9 6.2 5.9 6.1 6.3 6.4 6.2 6.2 6.2 6.2

Belgium 4.1 4.3 4.7 5.6 6.1 6.1 6.1 6.1 6.2 6.1 6.1 6.1 6.1

Brazil 3.6 4.6 3.9 4.4 5.4 5.5 5.5 5.6 5.7 6.1 6.1 6.1 6.1

Kiribati 8.8 6.1 6.1 6.1 6.1 6.1 6.1 6.1 6.1 6.1 6.1 6.1 6.1

Bolivia 3.1 3.5 4.8 5.6 7.2 6.6 6.1 6.1 6.1 6.1 6.1 6.1 6.1

South Africa 5.0 4.8 5.3 5.0 5.6 5.9 6.3 5.9 6.0 5.9 5.8 6.0 6.0

Tunisia 4.6 5.2 5.6 5.9 5.9 5.9 5.9 5.9 5.9 5.9 5.9 5.9 5.9

Czech Republic 4.3 4.3 3.4 3.7 3.9 4.0 4.1 3.9 3.8 5.7 5.6 5.6 5.6

Jamaica 2.6 4.3 5.6 4.8 6.2 6.4 6.3 6.3 6.1 5.5 5.4 5.3 5.6

Lesotho 2.8 4.2 7.2 8.7 8.9 8.5 8.0 7.6 7.2 6.8 6.3 5.9 5.5

United Kingdom 4.5 4.2 3.8 4.7 5.5 5.2 5.3 5.4 5.6 5.6 5.5 5.5 5.5

Luxembourg 2.5 3.5 3.8 4.3 4.9 5.0 5.1 5.2 5.3 5.5 5.5 5.5 5.5

Kyrgyz Republic 7.9 6.9 3.1 4.8 5.8 7.1 7.2 6.4 5.0 5.2 5.7 5.4 5.4

Mozambique 1.8 2.0 2.4 4.3 4.7 4.8 5.0 5.4 5.4 5.4 5.4 5.4 5.4

Israel 6.3 5.7 6.0 5.6 5.4 5.4 5.3 5.4 5.3 5.4 5.3 5.3 5.3

Cabo Verde 3.7 3.3 4.7 5.6 4.9 5.0 5.1 5.1 5.2 5.3 5.2 5.2 5.2

Morocco 3.3 5.0 5.5 7.0 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2

St. Vincent and the Grenadines 4.8 4.9 5.9 4.5 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2 5.2

Burundi 2.2 3.3 3.0 3.6 6.4 5.8 5.7 5.2 5.2 5.2 5.2 5.2 5.2

Austria 3.2 4.6 5.4 5.1 5.4 5.4 5.2 5.3 5.2 5.2 5.2 5.2 5.2

Ukraine 3.7 3.4 3.9 5.5 6.0 6.1 6.6 6.6 5.8 5.2 4.6 5.1 5.1

Australia 5.0 4.4 4.8 4.9 5.1 4.9 5.1 5.0 4.9 5.0 5.0 5.0 5.0

Dominica 5.4 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0 5.0

Argentina 1.4 1.0 4.6 3.5 4.5 4.9 5.2 5.2 5.1 5.3 5.1 5.0 5.0

Senegal 4.4 4.0 3.1 4.4 5.2 4.3 4.3 4.5 5.1 4.8 5.0 5.0 5.0

Uruguay 3.7 2.5 2.3 2.7 4.0 4.3 4.4 4.5 4.6 4.7 4.8 5.0 5.0

Barbados 5.5 6.4 4.4 5.6 5.8 5.6 5.4 5.9 6.4 5.9 5.5 5.0 5.0

Netherlands 5.2 5.1 4.0 4.5 4.8 4.8 5.5 4.8 4.8 4.7 5.0 5.0 5.0

France 2.9 4.3 4.9 4.9 5.1 5.0 5.0 4.9 5.0 4.9 4.9 4.9 4.9

Kenya 3.8 6.3 5.1 6.5 4.9 5.0 5.2 5.2 5.0 4.9 4.9 4.9 4.9

Canada 7.3 5.8 5.4 4.7 5.0 4.9 4.9 4.9 4.9 4.9 4.9 4.9 4.9

Estonia 5.6 5.6 5.0 4.6 5.4 4.8 4.4 4.3 5.1 4.8 4.9 4.9 4.9

Mexico 3.0 2.2 4.1 4.9 5.0 5.0 5.0 4.6 5.2 5.2 4.9 4.9 4.9

Togo 1.9 4.7 4.2 3.4 4.5 4.8 4.8 5.1 5.3 4.8 4.9 4.9 4.9

Portugal 3.3 3.3 5.0 5.0 5.5 5.1 4.5 5.2 5.1 4.8 4.8 4.8 4.8

Mauritius 2.9 3.1 3.4 3.5 3.4 3.2 3.2 3.5 4.8 4.8 4.8 4.8 4.8

Malta 5.8 3.4 4.0 5.1 6.5 7.9 7.2 7.0 6.9 4.7 4.7 4.7 4.7

Belarus 4.0 3.6 5.4 5.6 5.0 4.5 4.8 4.9 4.7 4.8 5.0 4.7 4.7

Vanuatu 7.4 4.4 6.1 5.5 5.0 4.9 4.9 4.9 4.8 4.8 4.7 4.7 4.7

Moldova 9.3 9.3 5.4 5.7 7.7 7.4 7.0 6.5 6.1 5.5 4.8 4.7 4.6

Malawi 3.4 2.4 4.5 3.7 4.1 4.9 4.9 4.8 6.9 5.7 4.6 4.6 4.6

Korea, Rep. 2.6 2.9 2.9 3.4 4.0 4.2 4.1 4.6 4.6 4.6 4.6 4.6 4.6

Vietnam 2.3 2.3 3.1 3.7 5.4 3.9 4.6 4.6 4.6 4.6 4.6 4.6 4.6

Iraq 4.7 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6 4.6

Poland 3.8 5.3 4.7 5.3 5.0 4.8 4.8 4.8 4.7 4.6 4.6 4.6 4.6

Chile 3.9 2.4 3.4 3.4 4.2 4.1 4.7 4.6 4.6 4.6 4.6 4.6 4.6

Switzerland 2.6 4.0 4.1 4.4 4.3 4.5 4.6 4.5 4.5 4.5 4.5 4.5 4.5

Seychelles 3.8 7.9 5.2 4.6 3.6 3.5 2.7 3.1 4.0 4.3 4.5 4.5 4.5

Croatia 3.5 3.5 3.5 3.7 4.1 4.2 4.3 4.5 4.5 4.5 4.5 4.5 4.5

Hungary 3.2 5.3 4.7 5.3 4.6 4.5 4.2 4.1 4.4 4.5 4.5 4.5 4.5

Algeria 5.2 4.9 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5 4.5

Egypt, Arab Rep. 4.4 3.3 4.4 4.4 4.4 4.4 4.4 4.4 4.4 4.4 4.4 4.4 4.4

United States 7.5 4.4 4.5 4.4 4.8 5.1 4.5 4.4 4.4 4.4 4.4 4.4 4.4

Maldives 4.3 4.3 3.6 4.3 4.6 3.9 5.6 4.2 3.8 4.7 4.4 4.4 4.4

Malaysia 5.0 4.1 4.3 4.7 5.0 5.6 5.3 6.1 5.1 4.8 4.6 4.5 4.4

Germany 4.1 4.1 4.1 4.1 4.7 4.5 4.7 4.5 4.5 4.4 4.4 4.4 4.4

Mongolia 8.8 7.4 5.5 4.2 4.4 4.2 5.6 5.2 5.1 4.6 4.9 4.3 4.3

Cote d'Ivoire 4.8 7.0 3.9 4.1 4.4 4.0 4.2 4.4 4.4 4.7 5.2 5.0 4.3

Burkina Faso 1.7 2.7 2.9 4.3 3.2 4.1 3.6 4.3 4.3 4.3 4.3 4.3 4.3

Slovenia 4.4 4.4 5.3 5.2 5.3 5.2 5.4 4.8 4.7 4.7 4.3 4.3 4.3

Latvia 3.2 3.4 5.0 4.4 4.4 4.3 5.8 6.1 4.3 4.5 4.3 4.3 4.3

Ghana 3.8 2.8 4.6 6.4 4.7 8.2 8.0 5.8 4.2 4.2 4.2 4.2 4.2

Samoa 3.6 3.6 3.6 4.0 4.2 4.2 4.2 4.2 4.2 4.2 4.2 4.2 4.2

Ireland 4.0 4.8 4.3 4.8 6.7 6.7 6.7 5.9 5.4 4.6 4.2 4.2 4.2

Thailand 2.3 3.0 4.5 4.1 3.5 4.6 4.5 4.2 4.2 4.2 4.2 4.2 4.2

Nicaragua 2.2 3.6 2.8 3.0 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1 4.1

Colombia 1.7 2.3 3.7 4.1 3.9 3.3 3.2 3.7 3.5 3.4 3.5 3.5 4.1

Benin 3.1 3.3 2.7 3.6 4.8 4.8 4.8 4.7 4.6 4.0 4.0 4.0 4.0

Spain 1.3 3.3 3.9 3.8 4.4 4.5 4.1 4.1 4.1 4.0 4.0 4.0 4.0

Brunei Darussalam 2.3 3.6 3.6 2.8 2.0 2.4 2.7 3.0 3.3 3.7 4.0 4.0 4.0

Fiji 3.7 4.6 5.0 5.8 4.6 4.4 4.2 4.0 4.0 4.0 4.0 4.0 4.0

Ecuador 1.6 6.7 1.2 2.5 3.9 4.0 3.9 3.9 3.9 3.9 3.9 3.9 3.9

Lithuania 4.8 4.8 5.7 4.6 4.9 4.7 4.3 4.1 3.9 3.8 3.9 3.9 3.9

Bulgaria 4.3 4.4 3.2 3.8 4.0 3.7 3.6 3.9 3.9 3.9 3.9 3.9 3.9

Bahamas, The 3.3 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8

Turkey 1.9 1.9 2.2 2.7 3.5 3.7 3.9 3.8 3.8 3.8 3.8 3.8 3.8

Mali 3.5 2.3 2.9 3.5 3.8 4.4 4.3 4.0 4.4 3.7 3.1 3.8 3.8

Serbia 4.4 4.4 4.4 4.4 4.6 4.5 4.2 4.1 4.0 3.9 3.7 3.8 3.8

Tajikistan 8.3 8.7 2.2 3.2 3.6 3.7 3.7 3.7 3.7 3.8 3.8 3.8 3.8

Slovak Republic 5.2 5.2 3.7 3.6 3.7 3.7 3.7 3.8 4.0 4.1 3.8 3.8 3.8

Grenada 5.0 5.4 4.7 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8 3.8

Tanzania 2.6 2.1 2.6 3.4 3.7 3.7 3.7 3.7 3.7 3.7 3.7 3.7 3.7

St. Lucia 6.9 5.3 5.7 5.0 4.2 4.2 4.0 4.8 4.5 4.3 4.1 3.9 3.7

Italy 3.4 3.0 4.1 4.0 4.1 3.9 3.9 3.9 3.9 3.9 3.7 3.7 3.7

Liberia 1.9 4.2 3.9 3.8 3.7 3.7 3.7 3.7 3.7 3.7 3.7 3.7 3.7`

 

const data1 = data.match(/^[A-Z]\D+(\d\W*){1,}/mgi)

 

const data10 = data1.map(d=>{

return d.match(/([a-z]\W*)+|(\d{1,}\W\d)/ig)

})

 

function randomsort(a, b) {

return Math.random()>.5 ? -1 : 1;

//用Math.random()函数生成0~1之间的随机数与0.5比较，返回-1或1

}

 

const dataS = data10.sort(randomsort).map((d)=>{

let item = {}

d.map((i, index)=> {

if(index==0)

item.label = i.split('\t')[0]

else if(index < 10)

item[2019-index] = parseFloat(i) * 100

else if(index < 12)

item[2005-(index-10) * 5] = parseFloat(i) * 100

else if(index == 12)

item[1990] = parseFloat(i) * 100

else if(index == 13)

item[1970] = parseFloat(i) * 100

})

return item

})

 

var fs = require("fs");

console.log("准备写入文件");

fs.writeFile('input.json', JSON.stringify(dataS, null, 2), function(err) {

if (err) {

return console.error(err);

}

console.log("数据写入成功！");

console.log("--------我是分割线-------------")

console.log("读取写入的数据！");

fs.readFile('input.json', function (err, data) {

if (err) {

return console.error(err);

}

console.log("异步读取文件数据: " + JSON.stringify(JSON.parse(data.toString())));

});

});