时间戳

首页 > 解决方案 > Powerquery：用2个双引号（“”）替换1个双引号（“）

powerbi - Powerquery：用2个双引号（“”）替换1个双引号（“）

问题描述

我想从 PowerBI 中的 CSV 文件创建一个 JSON，格式如下：

"{""data"": [{""AGE"": ""5"", ""SEX"": ""2"", ""BMI"": ""3.1"",""BP" ": ""3.1"", ""S1"": ""3.1"", ""S2"": ""3.1"", ""S3"": ""3.1"",""S4"": ""3.1"",""S5"": ""3.1"", ""S6"": ""3.1""}, {""AGE"": ""51"", ""SEX"": ""2"", ""BMI"": ""3.1"",""BP"": ""3.1"", ""S1"": ""3.1"", ""S2"": ""3.1"", ""S3"": ""3.1"",""S4"": ""3.1"",""S5"": " "3.1"", ""S6"": ""3.1""}]}"

我能够达到一个点（使用 Json.FromValue 和 Text.FromBinary），如下所示：{“数据”：

{"数据":[{"年龄":59,"SEX":1,"BMI":43,"BP":70,"S1":157,"S2":93.2,"S3":38," S4":4,"S5":4.8598,"S6":87,"Y":151},{"AGE":48,"SEX":1,"BMI":21.6,"BP":87," S1":183,"S2":103.2,"S3":70,"S4":3,"S5":3.8918,"S6":69,"Y":75}]}"

但仍然无法获得字段名称周围的双引号。

有人可以提供一些指导吗？

标签： powerbipowerquery

解决方案

当您想在字符串中指定双引号字符"时，您必须使用双双引号""，以便清楚您不打算结束字符串上下文。这意味着要获得双双引号，您需要使用四重双引号""""。

编辑：尝试变换 > 替换值功能：

替换值框

推荐阅读