Accessing nested values in a table

Processing Coding Questions
12

sorry, i by no way argue against the use of JSON,
still i wanted to show a way to use CSV / EXCEL&co / SQL /
and processing ‘table’

and actually

String data =
  "{"+
  " \"0\":{"+
  "     \"0\":[40.65, 20.30, 120.92, 86.12, 99.33],"+
  "     \"1\":[10.35, 90.10, 10.52,  1.12,  59.3],"+
  "     \"2\":[10.65, 62.10, 12.12,  96.23, 19.3],"+
  " }"+
  "}";

and this

 0,0,40.65, 20.30, 120.92, 86.12, 99.33
 0,1,10.35, 90.10, 10.52, 1.12, 59.3
 0,2,10.65, 62.10, 12.12, 96.23, 19.3

is both valid and not too much different,
but this

[(40.65, 20.30, 120.92, 86.12, 99.33), (10.35, 90.10, 10.52, 1.12, 59.3), (10.65, 62.10, 12.12, 96.23, 19.3)]

would require a new importer,
yes, loadStrings() and some split coding might do it too.

they https://www.w3.org/2013/csvw/wiki/Main_Page work on this?

2 Likes