String to 2Darray

[Belur]

Hi,

I am trying to create a 2d array(double) from a string of floating point

numbers(4 in a row and running into several lines). I am using the
function 'spreadsheet string to Array' and have wired '%f' for format string

conversion and null string for 'delimiter'. The output indicator shows only
the first column of the array correctly but the other (3) columns are not

shown indicating the output is only a one-dimensional array!


I can email the VI if someone is prepared to debug and let me know.

Many thanks in advance.

[Kevin_work]

Sheela Belur wrote:

> Hi,
>
> I am trying to create a 2d array(double) from a string of floating point
>
> numbers(4 in a row and running into several lines). I am using the
> function 'spreadsheet string to Array' and have wired '%f' for format string
>
> conversion and null string for 'delimiter'. The output indicator shows only
> the first column of the array correctly but the other (3) columns are not
>
> shown indicating the output is only a one-dimensional array!
>
> I can email the VI if someone is prepared to debug and let me know.
>
> Many thanks in advance.

Instead of using the "Null" string for a delimiter try either a TAB or several
spaces.
Depending on how the data is formated.
This function expects to see the data as follows
data 'delim' data 'delim'
data 'delim' .......
data 'delim' data 'delim' data 'delim' .......
data 'delim' data 'delim' data 'delim' .......
data 'delim' data 'delim' data 'delim' .......
.....
When you put the null string in, the function thinks it has the EOL so it goes
to the next row of data.

As far as I understand the question this is what you are seeing.

Kevin Kent