| keys_unsorted) as $keys | $keys, map( ]]) | put it together: $ sed '1s/^/' file | jq -r '(. The Text Import Wizard opens to the first of three steps. jq or jsoncsv that you have tried) instead of writing your own parser.Ĭonvert to json by simply adding after the last row and a comma to every except the last row. In the Ribbon, select File > Open > Browse, and then select the text or CSV file to be opened. "Outdated","Watt","Timestamp","A_Plus","A_Plus_HT","A_Plus_NT","A_Minus"įor me it seems easier and safer to first convert to proper json, then use a parser (e.g. You now have an array-of-arrays, with a header array at the top, that may be mapped back to an array of CSV (and finally to individual CSV rows): $ jq -r -slurp 'to_entries | perform a reduction of the array of rows, initializing it with the keys extracted from the 0 th element.
slurp the whole file into an indexed array of rows.If you do care about headers, it's more complicated. The structure resembles a JSON file, but unfortunately the structure does not quite match. I would like to convert a text file into CSV format.
0 kommentar(er)
