Using spreadsheet function to convert string to 1d array

[RavensFan]

Remember that the Spreadsheet String to Array function's lower left input is for the array type.  In this case a 1-D array of double.  It doesn't define a default value for the data so the empty NaN array isn't doing anything different than an empty 0 array, or even a 1-D array that contains actually contains data in its elements.

[AndreiN2014]

Hello !

I have another question concerning this post.

If the txt file contains 2 columns, how can i export it's content to a 2D array ?

Thak you very much 4 your time and patience !

P.S. Using LabView 8.5.1 on Windows XP SP 2

[AndreiN2014]

Let's say that the txt file is like the one attached.

[AndreiN2014]

Sorry. The solution is using read from spreadsheet.vi .

[Ray.R]

From the example I posted earlier, all that is required is a small change.

The delimiter becomes a space and use the 2D output (all rows). Also do not transpose the array, so the boolean becomes False.

See code

Message Edited by Ray.R on 01-06-2010 12:22 PM

[Anjella]

Hello to all!! I need to convert string of numbers to 1D array (Need to get each value of string to one column in array). Help please.

[GerdW]

Hi Anjella,

you should use SpreadsheetstringToArray, wire the correct delimiter char, default datatype and format specifier and you're done...

For any specific help you should give an example of your "string of numbers"!

[Anjella]

Thanks for replying 🙂 .

This is my example.

I realised the problem in this way 

[GerdW]

Hi anjelly,

so your problem is to convert exactly one number from string to DBL? Why don't you use a function from the string conversion palette?

Where do you have your "string of numbers"?

In your example you didn't wire the delimeter nor format string nor default datatype...

[Anjella]

but i want to find solution using SpreadsheetstringToArray function.