用正则从参数中提取指定字符串,该怎么写?

{"id":"123456","ask":"","ans":"拨款","name":"名称","per":"西部","num":"65","money":"10,134.7万(元)","rate":"83.59%","link":"abshrhtnj","col":"10134.705700"}
用正则从中提取出以下参数,应该怎么写
namemoney:
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)

控制台输出如下:

img

如果需要返回的话可采取如下方式:

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)