change the format of a string

[jcraffael]

Hello all,

Now what shall I do is to convert a string to an array.

The string I got is shown in the pic in attachment, together with my code.

Obviously the array isn't correct.

i wonder if there's a way to change the format of the string without the empty lines, and concatenate each number after another,

in order to have a correct array with my code.

Or someone has idea to make a new code for converting a string like this to array?

Thanks

Chao

[GerdW]

Hi Chao,

1. Use SpreadsheetStringToArray with a comma (or NewLine) as separator...

2. Attach your VI instead of a picture. So we would have the option to edit the VI...

[jcarmody]

Spreadsheet String to Array

<edit> Race condition.  I lost to GerdW.

[jcraffael]

Hi Gerd!

Here is my VI. Actually I figured out a simple way to implement this, just by

adding a Trimwhitespace.vi between the input string and match pattern, and that works!

I'm still glad to know how do you use spreadsheetstringtoarray.

Thanks in advance if you can show me that!

Chao

[ErnieH · Accepted solution]

I think they are referencing something like this.

[jcraffael]

Wonderful! That's it.

Thanks a lot for the reply!

Chao