如{"a":""abc","d":"goods","c":":"yellow"}，要取“d":"goods"怎么做
arr = Split([a1], ",")
[a2] = arr(1)
End Sub追问
还有其他办法吗？能不能精准提取，假如有的"d"前面有两个逗号就不行了
温馨提示：答案为网友推荐，仅供参考
vba取字符串中的一段匹配的字符串，或用正则表达式
arr = Split([a1], ",")
[a2] = arr(1)
End Sub追问
