spreadsheet string to array conversion Question

[jon_mcbee]

Hello,

I am using the spreadsheet string to array.vi and have a question on how it works.  I have a long string, alphanumeric, and I need to convert it to a 2D array or numbers.  Currently the letters are converted to zeroes to fill the gaps.  Is there a way to change that so that the letters are converted to -9999 or -1 or something else of my chosing? Please let me know if you have any ideas.

Cheers!

[altenbach]

"Spreadsheet string to array" does not support this functionality directly. However, you could easily write your own subVI that would support it. 🙂

[jon_mcbee]

Good call, it was a good exercise too!

Cheers!