将JSON数组转换为保留空白的bash数组 [英] convert JSON array to bash array preserving whitespaces

问题描述

我想将JSON文件转换为bash字符串数组，以后可以对其进行迭代.我的JSON结构如下:

I want to transform JSON file into bash array of strings that i will later be able to iterate over. My JSON structure is as follows:

[
  {
    "USERID": "TMCCP",
    "CREATED_DATE": "31/01/2020 17:52"
  },
  {
    "USERID": "TMCCP",
    "CREATED_DATE": "31/01/2020 17:52"
  }
]

这是我的bash脚本:

And this is my bash script:

test_cases=($(jq -c '.[]' data.json))
echo ${test_cases[0]}
echo ${test_cases[1]}
echo ${test_cases[2]}
echo ${test_cases[3]}

如您所见，它返回包含4个元素而不是2个元素的数组.输出:

As you can see it returns array with 4 elements instead of 2. Output:

{"USERID":"TMCCP","CREATED_DATE":"31/01/2020
17:52"}
{"USERID":"TMCCP","CREATED_DATE":"31/01/2020
17:52"}

由于某些原因，日期字段中包含空格会导致某些解析问题.知道如何克服这个问题吗?

For some reason having whitespace in date field causes some parsing issues. Any idea how to get over this?

推荐答案

使用 readarray 代替.

$ readarray -t test_cases < <(jq -c '.[]' file)
$ declare -p test_cases
declare -a test_cases=([0]="{\"USERID\":\"TMCCP\",\"CREATED_DATE\":\"31/01/2020 17:52\"}" [1]="{\"USERID\":\"TMCCP\",\"CREATED_DATE\":\"31/01/2020 17:52\"}")

和read可以按如下所示使用，其中readarray不可用.

And read can be used as shown below where readarray is unavailable.

IFS=$'\n' read -d '' -a test_cases < <(jq -c '.[]' file)

这篇关于将JSON数组转换为保留空白的bash数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！