需要从字符串中捕获名称。 [英] Need to capture the name from string.
问题描述
我有一个名为Record Owner的专栏。因为数据存储如下。
I have a column called Record Owner. In that the data is stored as below.
{id:abcd,email:miki @ gmail.com,name:Miki john},{id:efgh,email:kelseys @ gmail。 com,名字:Kelsey kate}
{id:abcd,email:miki@gmail.com,name:Miki john},{id:efgh,email:kelseys@gmail.com,name:Kelsey kate}
{id:asdf,email:jack @ gmail.com,name:jack kite}
{id:asdf,email:jack@gmail.com,name:jack kite}
我想要捕获名称,我需要显示如下数据。
I want to capture name and i need the data to be display as below.
Miki John,Kelsey Kate
Miki John, Kelsey Kate
Jack Kite
Jack Kite
谢谢,
cvsuman
推荐答案
< span style ="font-size:0.75em"> {id:abcd,email:miki @ gmail.com,name:Miki john},{id:efgh,email:kelseys @ gmail.com,name:Kelsey kate} {id:asdf,email:jack @ gmail.com,name:jack kite}
这看起来像JSON数据,但形式不佳。你能确认吗?
This looks like JSON data but not well formed. Can you confirm?
可以很容易地使用JSON_QUERY查询格式良好的JSON。
A well formed JSON can be queried using JSON_QUERY easily.
这篇关于需要从字符串中捕获名称。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!