Read a string text file and transform it into string array

[OBN]

Hello
How Can I read a string txt file and transform it into a string array ?
The function SpreadSheet To Array seems to accept only dbl type array?
Is it possible to modify the array type ?

[tst]

You can modify the original Read from spreadsheet file VI to read a string array by double clicking it, just make sure you don't overwrite the original file. I'm attaching a quick and dirty example.

[chilly_charly]

---

@OBN wrote:
The function SpreadSheet To Array seems to accept only dbl type array?

---

Wrong ! Just wire a string array constant as input (bottom left) as in the attached example.

Happy New Wire !

CC

[OBN]

Thank-you

But how do you change the type of the "SpreadSheet String to Array" from Array Type "2D Dbl" to "string"?

[OBN]

Hi Charly

May you save in 7.0 version?

Regards

Happy New year to you also

[chilly_charly]

Here it is !

CC

[OBN]

Cool Thanks

[tst]

HEY! CC! Don't be so judgemental. Be more Chilly.
First, it works. So even if it's problematic it isn't wrong. Second, the reason I prefer this method is that it allows you to read spreadsheet files that have text as well as numbers.
As for OBN's question of how to replace the DBL array with a string one - after you double-click the read VI, find the 2D DBL array on the right, right-click one of the controls and from the pop-up menu select replace and select a string control instead. Just remember (very important) to save the file under another name so that you don't overwrite NI's VI.

[tst]

O.K. CC, here's an apology. I misread your post.

[tst]

Also, I just wanted to say that the read VI itself has a "format" input, although from what I could tell, it doesn't convert to string.