removing first and last character and empty spaces from a json file [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? As written, this question is lacking some of the information it needs to be answered. If the author adds details in comments, consider editing them into the question. Once there's sufficient detail to answer, vote to reopen the question.

Closed last year.

Improve this question

I have given sets of different input files as shown sample below

cat out.txt

[
  {
    "regional_unit": "node",
    "source_name": "1753250187_SPS", 
    "technology": "STP", 
    "temporal_unit": "15min", 
    "timestamp_column_name": "collectTime", 
    "timestamp_column_pattern": "yyyyMMddHHmmss", 
    "vendor": "HUA"
  }
]

I want to read such files from the directory and want to remove [ & ] and also the empty spaces

You mean as in jq -c '.[]' out.txt? Do you want to modify the files in place or just output the result? Can the arrays have more than one element? Can you post the expected output? — Stéphane Chazelas
– Stéphane Chazelas, Commented Nov 6, 2024 at 13:23
Please edit your question and show us the output you would want from that example input. Also explain if you want this output in the same file, overwriting the original, or if you want it saved to a new file or just printed to the terminal. — terdon
– terdon ♦, Commented Nov 6, 2024 at 16:33

Kusalananda · Accepted Answer · 2024-11-06 18:38:03Z

To expand the top-most array into a set of objects, you may use jq like so:

$ jq '.[]' file
{
  "regional_unit": "node",
  "source_name": "1753250187_SPS",
  "technology": "STP",
  "temporal_unit": "15min",
  "timestamp_column_name": "collectTime",
  "timestamp_column_pattern": "yyyyMMddHHmmss",
  "vendor": "HUA"
}

If you want jq to produce "compact" output (which removes unnecessary whitespace), then add the -c (or --compact-output) option:

$ jq -c '.[]' file
{"regional_unit":"node","source_name":"1753250187_SPS","technology":"STP","temporal_unit":"15min","timestamp_column_name":"collectTime","timestamp_column_pattern":"yyyyMMddHHmmss","vendor":"HUA"}

This would produce one line of output per entry in the original array.

Stack Exchange Network

removing first and last character and empty spaces from a json file [closed]

1 Answer 1

Hot Network Questions

removing first and last character and empty spaces from a json file [closed]

1 Answer 1

Related

Hot Network Questions