Page 1 of 1

the spreadsheet paradigm

Posted: 15 Nov 2022, 21:25
by oli_lab
Hi,
I'm planning a series of modules to be able to write/read/append and sort out cvs files.
The planned use will be to select samples from a vast bank of wavefiles from various quantified critrerias.
The question is what format should have the output of the file :
a single commatext out with all the data + a nb of columns output ?
as many outputs as the nb of columns ?

the first line of the cvs will tell the format of each column (s,f,i) and be output as a commatext + input
the second line of the cvs will be the label of each column and be output as a commatext + input

also, some columns will be text (typically filenames) and other float or int
with only one commatext output, a conversion will be necessary from string to int or string to float ?
or I could have a commatext output + an array output for floats and int ?

thanx for advice

Olivar

Re: the spreadsheet paradigm

Posted: 16 Nov 2022, 09:58
by senso
juste a reflection, we already use in Global Arrays

2 outs for line 0 and 1 (title, and type) and you could have 2 inputs to be able to retrieve any element of the CSV:

line and column
and one output to get the result.

(23 ; 12) sends the element line 23, column 12
(4 ; -1) sends the line 4 as a commatext
(-1 ; 5) sends the column 5 as a commatext
(2,3,4,5 ; -1) sends the lines 2,3,4,5 as a commatext
(-1,-1) sends all the CSV values as commatext

Re: the spreadsheet paradigm

Posted: 16 Nov 2022, 21:51
by oli_lab
Hi !
I like that !
Is it already implemented in global arrays in HH5 ?

I did some digging : global arrays could do the trick : one global array per column
Exept that the files will be very tricky to edit

I just have to make a special module for sorting the columns all at once.

first I have another job to finish ;-)

Many Thanx