Want to create a mask for a file...where do I start?

[vincentm77]

Hi everyone,
on my computer I have plenty of text files which I use to configure an audio device (actually a Line6 guitar multieffect HX Stomp), and these files look like the example hereunder.
So there are lots of {}, parameters in “”, mostly starting with a arobase-, for instance

“arobase-model” : “HD2_DistScream808”

What I would like to do is to be able to open such files in LibreOffice (calc), with a formatting enabling to clearly read the parameters.
For instance, in the example hereunder, there is a function block called “HD2_DistScream808”, with parameters:

 "arobase-enabled" : false,
 "arobase-model" : "HD2_DistScream808",
 "arobase-no_snapshot_bypass" : false,
 "arobase-path" : 0,
 "arobase-position" : 1,
 "arobase-stereo" : true,
 "arobase-type" : 0,
 "Gain" : 0.520,
 "Level" : 0.670,
 "Tone" : 0.650

I would like to have these info organized automatically in a spreadsheet.

How do I start do this ?!

Thanks for any hint !
Vincent

Example:

{
“data” : {
“device” : 2162699,
“device_version” : 56623104,
“meta” : {
“application” : “HX Edit”,
“appversion” : 56688640,
“build_sha” : “v3.50-25-g9dead52”,
“modifieddate” : 1695565543,
“name” : “SAD B TRUE”
},
“tone” : {
“controller” : {
“dsp0” : {
“block2” : {
“ChVol” : {
“arobase-controller” : 12,
“arobase-max” : 1.0,
“arobase-min” : 0.0,
“arobase-snapshot_disable” : false
},
“Drive” : {
“arobase-controller” : 12,
“arobase-max” : 1.0,
“arobase-min” : 0.0,
“arobase-snapshot_disable” : false
}
}
}
},
“dsp0” : {
“block0” : {
“arobase-enabled” : true,
“arobase-model” : “HD2_Chorus”,
“arobase-no_snapshot_bypass” : false,
“arobase-path” : 0,
“arobase-position” : 0,
“arobase-stereo” : true,
“arobase-type” : 0,
“Depth” : 0.810,
“Level” : 0.0,
“Mix” : 0.20,
“Predelay” : 0.320,
“Speed” : 0.250,
“Spread” : 1.0,
“SyncSelect1” : 6,
“TempoSync1” : false,
“Tone” : 0.50,
“WaveShape” : 2
},
“block1” : {
“arobase-enabled” : false,
“arobase-model” : “HD2_DistScream808”,
“arobase-no_snapshot_bypass” : false,
“arobase-path” : 0,
“arobase-position” : 1,
“arobase-stereo” : true,
“arobase-type” : 0,
“Gain” : 0.520,
“Level” : 0.670,
“Tone” : 0.650
},

[vincentm77]

I just want to mention that in this post, I had to replace all arobase symbols with “arobase-”.
Otherwise I could not post my question…

[ajlittoz]

The trick is to escape special characters with reverse solidus as \@ to get @. So, please, edit your question to make it look like data in your files. This is not a forum; in such a question-and-answers site, questions are always modifiable.

Another formatting trick: start your source examples with a line made of at least 3 tildes ~~~ and end the example with the same line. You can indent code and indentation will be kept. And also no need to escape special characters because this is a code snippet. You exit “code mode” when reaching the ~~~ sentinel.

[LeroyG]

@vincentm77,
This site, on cites (with > symbol), will change quotes with curly quotes.
Instead of cite, use code (with grave accent, as wrote @ajlittoz).
What about the extra spaces (indent, not seen in the cite) to the left of some lines?