如何格式化单元格内的json数据

mysql数据库字段存储的是json数据，怎么样可以把json解析出来，放到单元格内，另外json数据里有很多信息，希望能放到多个单元格里

FineReport 帆软用户Jor7AGUAlG 发布于 2023-9-19 16:46

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

用户k6280494Lv6资深互助
发布于2023-9-19 16:49（编辑于 2023-9-20 09:48）

尝试自定义函数

自定义函数集合

JOINARRAY(array,sepa):返回一个由sepa作为分隔符的字符串.

array:[arg1,arg2...]格式的数组;

sepa:分隔符。

示例:

JOINARRAY([1,2],";") = [1;2].

JOINARRAY([hello,world],"-") = [hello-world].

GREPARRAY(SPLIT(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A3,"{",""),"}",""),":",",")," ",""),"\"",""),"name,",""),"value,",""),","),index % 2=1)标题

GREPARRAY(SPLIT(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A3,"{",""),"}",""),":",",")," ",""),"\"",""),"name,",""),"value,",""),","),index % 2=0)内容

举报收起评论(2)

帆软用户Jor7AGUAlG(提问者) [{ \"name\": \"标准\", \"value\": \"GB/T 5781\" }, { \"name\": \"规格\", \"value\": \"M18-2.50X90\" }, { \"name\": \"直径\", \"value\": \"M18\" }, { \"name\": \"长度\", \"value\": \"90\" }, { \"name\": \"强度\", \"value\": \"CL 4.8\" }, { \"name\": \"全牙/半牙\", \"value\": \"全牙\" }, { \"name\": \"表面处理\", \"value\": \"白皮\" }], 这种类型的数据能处理吗？每一个name是一个表头，value是对应的值

2023-09-19 17:06