{"id":"123456","ask":"","ans":"拨款","name":"名称","per":"西部","num":"65","money":"10,134.7万(元)","rate":"83.59%","link":"abshrhtnj","col":"10134.705700"}
用正则从中提取出以下参数,应该怎么写
name:
money:
rate:
col:
要写入数据库,必须提取出内容
首先你的数据是字典类型,其次要使用正则表达式提取数据,待提取数据必须是字符串类型,如果你的需求是要写入数据库,必须提取出内容,可采取如下方法:
data = {'id':'123456','name':'名称','money':'112210万元','rate':'83.48%','col':'10134.705700'}
print(type(data))
name = data.get('name')
money = data.get('money')
rate = data.get('rate')
col = data.get('col')
print(name,money,rate,col)
控制台输出如下:
如果需要返回的话可采取如下方式:
yield {
name = data.get('name'),
money = data.get('money'),
rate = data.get('rate'),
col = data.get('col')
}
建议有空去补一下基础吧,加油!
必须是正则吗?你这已经是json数据了,直接用对象的形式取出键值对更方便点,如果是json字符串,可以转成json对象,例如
var obj= '{"id":"123456","ask":"","ans":"拨款","name":"名称","per":"西部","num":"65","money":"10,134.7万(元)","rate":"83.59%","link":"abshrhtnj","col":"10134.705700"}'
var obj=JSON.parse(obj)
console.log(obj.name)
console.log(obj.money)
console.log(obj.col)