将无效的json转换为有效的json
束建章
问题内容：
问题答案：
我正在尝试从Web服务器读取.json文件。
我从服务器接收到的JSON在http://jsonlint.com/上报告无效：
{
preOpen: "900",
preClose: "908",
mktOpen: "915",
mktClose: "1530",
corrOpen: "1540",
corrClose: "1600",
mktStatusCode: "3",
status: "MARKET OPEN",
time: "Jan 11, 2012 12:32:14",
data: [
{
name: "S&P CNX NIFTY Pre Open",
lastPrice: "4,863.15",
change: "13.60",
pChange: "0.28",
imgFileName: "S&P_CNX_NIFTY_Pre_Open_open.png"
},
{
name: "S&P CNX NIFTY",
lastPrice: "4,871.15",
change: "21.60",
pChange: "0.45",
imgFileName: "S&P_CNX_NIFTY_open.png"
},
{
name: "CNX NIFTY JUNIOR",
lastPrice: "8,940.05",
change: "91.90",
pChange: "1.04",
imgFileName: "CNX_NIFTY_JUNIOR_open.png"
},
{
name: "BANK NIFTY",
lastPrice: "8,816.15",
change: "81.10",
pChange: "0.93",
imgFileName: "BANK_NIFTY_open.png"
},
{
name: "INDIA VIX",
lastPrice: "24.18",
change: "0.18",
pChange: "0.75",
imgFileName: "INDIA_VIX_open.png"
},
{
name: "CNX 100",
lastPrice: "4,729.25",
change: "25.05",
pChange: "0.53",
imgFileName: "CNX_100_open.png"
},
{
name: "S&P CNX DEFTY",
lastPrice: "3,265.00",
change: "41.70",
pChange: "1.29",
imgFileName: "S&P_CNX_DEFTY_open.png"
},
{
name: "S&P CNX 500",
lastPrice: "3,811.75",
change: "26.40",
pChange: "0.70",
imgFileName: "S&P_CNX_500_open.png"
},
{
name: "CNX MIDCAP",
lastPrice: "6,548.20",
change: "80.65",
pChange: "1.25",
imgFileName: "CNX_MIDCAP_open.png"
},
{
name: "NIFTY MIDCAP 50",
lastPrice: "1,937.20",
change: "21.30",
pChange: "1.11",
imgFileName: "NIFTY_MIDCAP_50_open.png"
},
{
name: "CNX INFRA",
lastPrice: "2,273.60",
change: "8.50",
pChange: "0.38",
imgFileName: "CNX_INFRA_open.png"
},
{
name: "CNX REALTY",
lastPrice: "207.85",
change: "8.10",
pChange: "4.06",
imgFileName: "CNX_REALTY_open.png"
},
{
name: "CNX ENERGY",
lastPrice: "7,300.55",
change: "37.10",
pChange: "0.51",
imgFileName: "CNX_ENERGY_open.png"
},
{
name: "CNX FMCG",
lastPrice: "10,308.90",
change: "10.90",
pChange: "0.11",
imgFileName: "CNX_FMCG_open.png"
},
{
name: "CNX MNC",
lastPrice: "4,660.35",
change: "30.40",
pChange: "0.66",
imgFileName: "CNX_MNC_open.png"
},
{
name: "CNX PHARMA",
lastPrice: "4,743.15",
change: "-4.15",
pChange: "-0.09",
imgFileName: "CNX_PHARMA_open.png"
},
{
name: "CNX PSE",
lastPrice: "2,753.90",
change: "14.60",
pChange: "0.53",
imgFileName: "CNX_PSE_open.png"
},
{
name: "CNX PSU BANK",
lastPrice: "2,847.95",
change: "22.80",
pChange: "0.81",
imgFileName: "CNX_PSU_BANK_open.png"
},
{
name: "CNX SERVICE",
lastPrice: "5,933.65",
change: "21.65",
pChange: "0.37",
imgFileName: "CNX_SERVICE_open.png"
},
{
name: "CNX IT",
lastPrice: "6,300.35",
change: "-31.40",
pChange: "-0.50",
imgFileName: "CNX_IT_open.png"
},
{
name: "CNX SMALLCAP",
lastPrice: "2,981.80",
change: "49.85",
pChange: "1.70",
imgFileName: "CNX_SMALLCAP_open.png"
},
{
name: "CNX 200",
lastPrice: "2,432.05",
change: "14.35",
pChange: "0.59",
imgFileName: "CNX_200_open.png"
},
{
name: "CNX AUTO",
lastPrice: "3,497.60",
change: "4.05",
pChange: "0.12",
imgFileName: "CNX_AUTO_open.png"
},
{
name: "CNX MEDIA",
lastPrice: "1,147.30",
change: "23.35",
pChange: "2.08",
imgFileName: "CNX_MEDIA_open.png"
},
{
name: "CNX METAL",
lastPrice: "2,746.95",
change: "60.60",
pChange: "2.26",
imgFileName: "CNX_METAL_open.png"
}
]
}
它显示以下测试结果：
Parse error on line 1:
{ preOpen: "900",
-----^
Expecting 'STRING', '}'
在使用PHP解析之前，如何将其转换为VALID JSON？
问题答案：
所有键（preOpen，preClose等）都必须是字符串，因此它们需要用双引号引起来。
{
"preOpen": "900",
"preClose": "908",
...
}
===更新===
如果您的Json-String无效，则可以使用以下脚本对其进行转换：
$sInvalidJson = '{
preOpen: "900",
preClose: "908"
}';
$sValidJson = preg_replace("/(\n[\t ]*)([^\t ]+):/", "$1\"$2\":", $sInvalidJson);
另请参见此示例。
（此脚本仅适用于上述无效的JSON，否则必须更改模式。）
===更新===
$sInvalidJson = '{preOpen:"900",preClose:"908",mktOpen:"915",mktClose:"1530",corrOpen:"1540",corrClose:"1600",mktStatusCode:"3",status:"MARKET OPEN",time:"Jan 11, 2012 14:25:15",data:[{name:"S&P CNX NIFTY Pre Open",lastPrice:"4,863.15",change:"13.60",pChange:"0.28",imgFileName:"S&P_CNX_NIFTY_Pre_Open_open.png"},{name:"S&P CNX NIFTY",lastPrice:"4,847.85",change:"-1.70",pChange:"-0.04",imgFileName:"S&P_CNX_NIFTY_open.png"},{name:"CNX NIFTY JUNIOR",lastPrice:"8,917.00",change:"68.85",pChange:"0.78",imgFileName:"CNX_NIFTY_JUNIOR_open.png"},{name:"BANK NIFTY",lastPrice:"8,768.75",change:"33.70",pChange:"0.39",imgFileName:"BANK_NIFTY_open.png"},{name:"INDIA VIX",lastPrice:"24.61",change:"0.61",pChange:"2.54",imgFileName:"INDIA_VIX_open.png"},{name:"CNX 100",lastPrice:"4,707.85",change:"3.65",pChange:"0.08",imgFileName:"CNX_100_open.png"},{name:"S&P CNX DEFTY",lastPrice:"3,253.50",change:"30.20",pChange:"0.94",imgFileName:"S&P_CNX_DEFTY_open.png"},{name:"S&P CNX 500",lastPrice:"3,795.40",change:"10.05",pChange:"0.27",imgFileName:"S&P_CNX_500_open.png"},{name:"CNX MIDCAP",lastPrice:"6,524.90",change:"57.35",pChange:"0.89",imgFileName:"CNX_MIDCAP_open.png"},{name:"NIFTY MIDCAP 50",lastPrice:"1,926.55",change:"10.65",pChange:"0.56",imgFileName:"NIFTY_MIDCAP_50_open.png"},{name:"CNX INFRA",lastPrice:"2,262.05",change:"-3.05",pChange:"-0.13",imgFileName:"CNX_INFRA_open.png"},{name:"CNX REALTY",lastPrice:"207.70",change:"7.95",pChange:"3.98",imgFileName:"CNX_REALTY_open.png"},{name:"CNX ENERGY",lastPrice:"7,301.05",change:"37.60",pChange:"0.52",imgFileName:"CNX_ENERGY_open.png"},{name:"CNX FMCG",lastPrice:"10,235.35",change:"-62.65",pChange:"-0.61",imgFileName:"CNX_FMCG_open.png"},{name:"CNX MNC",lastPrice:"4,631.55",change:"1.60",pChange:"0.03",imgFileName:"CNX_MNC_open.png"},{name:"CNX PHARMA",lastPrice:"4,749.95",change:"2.65",pChange:"0.06",imgFileName:"CNX_PHARMA_open.png"},{name:"CNX PSE",lastPrice:"2,744.85",change:"5.55",pChange:"0.20",imgFileName:"CNX_PSE_open.png"},{name:"CNX PSU BANK",lastPrice:"2,841.10",change:"15.95",pChange:"0.56",imgFileName:"CNX_PSU_BANK_open.png"},{name:"CNX SERVICE",lastPrice:"5,900.60",change:"-11.40",pChange:"-0.19",imgFileName:"CNX_SERVICE_open.png"},{name:"CNX IT",lastPrice:"6,262.10",change:"-69.65",pChange:"-1.10",imgFileName:"CNX_IT_open.png"},{name:"CNX SMALLCAP",lastPrice:"2,963.90",change:"31.95",pChange:"1.09",imgFileName:"CNX_SMALLCAP_open.png"},{name:"CNX 200",lastPrice:"2,421.50",change:"3.80",pChange:"0.16",imgFileName:"CNX_200_open.png"},{name:"CNX AUTO",lastPrice:"3,484.30",change:"-9.25",pChange:"-0.26",imgFileName:"CNX_AUTO_open.png"},{name:"CNX MEDIA",lastPrice:"1,139.60",change:"15.65",pChange:"1.39",imgFileName:"CNX_MEDIA_open.png"},{name:"CNX METAL",lastPrice:"2,726.75",change:"40.40",pChange:"1.50",imgFileName:"CNX_METAL_open.png"}]}';
$sValidJson = preg_replace("/([{,])([a-zA-Z][^: ]+):/", "$1\"$2\":", $sInvalidJson);
也是这个更新的例子。
类似资料：
-
我有包含非法字符的json 我想要从服务器spring发送到客户端的明文，这样客户端就可以获得完整的数据。 如何将字符串的非法字符替换为有效的json对象？
-
问题内容： 我有一个无效的json字符串，如下所示， 我尝试使用JSON.parse将其转换为对象。但是，这不是有效的json字符串。是否有任何函数可以将这种无效格式转换为有效的json字符串或直接转换为对象？ 问题答案： 如果您的示例语法与真实JSON相同，则JSONLint表示您需要对名称和值使用双引号。 仅在这种情况下，请使用以下替换调用： 但是，您首先应该尝试使用有效的Json。
-
问题内容： 以下代码使用和将转换为JSON字符串。 有没有更快的方法？ 有没有一种方法可以使用更少的内存？ 问题答案： 由于JIT编译器只是分支和基本测试，因此它可能会使其变得非常快。您可以通过对回调进行HashMap查找来使其更加优雅，但我怀疑这样做会更快。至于记忆，这是非常苗条的。 我以某种方式怀疑此代码实际上是内存或性能的关键瓶颈。您有真正的理由尝试对其进行优化吗？
-
问题内容： 我最近使用的Train status API在JSON对象中添加了两个额外的键值对，这导致我的脚本崩溃。 这是字典： 毫不奇怪，我得到了以下错误： 如果我没记错的话，我认为这是因为JSON响应中的布尔值是/，而Python可以识别/ 。有什么办法解决吗？ PS：我尝试将的JSON响应转换为字符串，然后将其转换回布尔值，结果发现如果字符串中有任何字符，我总会得到一个值。我有点卡在这里。
-
我试图写一个规范来使用jolt转换完成下面的转换。我需要将平面JSON转换成嵌套JSON。 输入数据: 我在将平面JSON转换为嵌套JSON时遇到了一些问题。这里，我希望基于stoptype属性聚合数据，并且需要针对唯一的有效负载进行聚合。我用https://jolt-demo.appspot.com来测试以下内容。 输出： 你能帮我完成这个预期的输出吗？
-
问题内容： 我想使用JSON发送大字节数组启发了我，为了减少开销，我想使用base128编码（实际上可以产生有效的json字符串）。但不幸的是，我无法找到一些在JS中进行转换的过程。我将发布过程作为对此问题的答案，但是可能是某人的过程更短，或者可能是在JSON中有效发送二进制数据的更好的主意。 问题答案： ES6： 编码 解码 我在这里嵌入功能-这里。这里的掩盖思想是将字节数组转换为位数组，然后将