我有下面格式的json数据,我只需要将“text”字段插入到配置单元的表中。
[
{
"fullname": "Jia Khan",
"id": "832576802904240129",
"likes": "1",
"replies": "0",
"retweets": "0",
"text": "This is gonna be an intense showdown only if the weather showed some mercy. @PeshawarZalmi #AbKhelJamayGa #PZvQG #HarDilZalmi #HBLPSL",
"timestamp": "2017-02-17T13:05:52",
"user": "iamJiaKhan"
}
]
1条答案
按热度按时间wn9m85ua1#
首先,您可以为所有数据字段创建一个临时表,然后您可以通过从临时表中仅选择一个必需字段来创建最终表。