LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

string array into number

Solved!
Go to solution

Hi,

 

I am trying to get this array of strings into numbers, from the attached file. I just need that table of values from the file.

Any help?

Download All
0 Kudos
Message 1 of 6
(3,066 Views)
Solution
Accepted by topic author agyna

You cannot directly read a file saved in the Excel format.  You need to save the spreadsheet as a tab delimited text file.  And after that, there are some minor tweaks that can be made to your VI to get what you want.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
Download All
0 Kudos
Message 2 of 6
(3,058 Views)

Perfect! 

 

Thanks a lot.

0 Kudos
Message 3 of 6
(3,048 Views)

Oh, and it's not an Excel spreadsheet, so don't name it *.xls.  Use *.txt instead.  It's a text file.  *xls will fool a computer that doesn't have Excel into thinking it cannot read it, when it is actually perfectly readable with notepad.

Bill
CLD
(Mid-Level minion.)
My support system ensures that I don't look totally incompetent.
Proud to say that I've progressed beyond knowing just enough to be dangerous. I now know enough to know that I have no clue about anything at all.
Humble author of the CLAD Nugget.
0 Kudos
Message 4 of 6
(3,023 Views)

Bill;

 

If I may ask a follow up question: I have a table of numbers much like the above section. How can I extract the values from, for instance, the first column, first row and first column third row? I've got a string of tab delimited information, I can get it into a chart, but I cant seem to find a way to retrieve (just) the first and third value.

 

i appreicate your thoughts.

0 Kudos
Message 5 of 6
(2,857 Views)

Index Array


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 6 of 6
(2,845 Views)