Array data type conversion

[murchak]

I have a simple problem.

I have a 2D array of string type. The array is a table with column names, and rows which are numbers.

I want to extract the rows, but I want them to come out as numbers so I can do some line fitting to them.

Do I need to select each element and convert from string to number?

Is there a function that converts a string (pink line) to a number (orange line)?

Is there a smarter way?

[Robin11]

Try this...

on the blockdiagram right click go to programming-->strings-->string/numberconversion-->fract/exp stringtonumber

Thanks

Robin

[murchak]

Thanks. Your solution works but element-wise.

But is there a VI that applies to the whole 2D array to change its type?

[johnsold]

Spreadsheet String to Array in the String palette.

Lynn

[MoReese]

Put the 2D array through a For loop.  See attached.

[RavensFan · Accepted solution]

---

@murchak wrote:

Thanks. Your solution works but element-wise.

But is there a VI that applies to the whole 2D array to change its type?

---

??

It works on an entire array at a time in my version of LabVIEW!

 

[murchak]

It does indeed work on an entire array. Thanks!!