Pick out words from a string with tabs?

[Ex-jobb]

Hello!

Now we have the following problem: We have an array of strings. In each string there is five words. These are separated with tabs. We now want to get these words separeted in another array. Any tip? Best regards!

[GerdW]

Hello Ex-jobb,

have you tried "Spreadsheet String to Array"? It can be found in the string palette.

Best regards,
GerdW

[NeilR]

Hi Ex-jobb

There are several ways to do this, see attached VI for a couple of options.

Good luck
Neil

[Ex-jobb]

Hello!

Thank you for your answer. We tried something like that but it did not work. So now we know what we did wrong 🙂 Now there is one more thing. That is between two of the columns there are no tab, but we want to pick these words out too... can one do this? Because this words "disappear" because there is no tab there is just space. Numbers of space here between can be different too... best regards.

[NeilR]

Hi Ex-jobb

In Method 1 in the example I attached I use Scan String For Tokens.vi which allows for several delimiters to be detected including spaces and tabs. If you look at the Context Help it will explain. If you delete Method 2 from the example, and change one of the tabs (\t) in "Array" to a space (\s) or even multiple spaces you will find it will work just as well. 🙂

Hope that helps.
Neil

[Ex-jobb]

Hello!

Thank you 🙂 We will try that 🙂

[Ex-jobb]

Hello again 🙂

We wonder if there is any other way to do this? We would like to avoid the build array-VI...? We mean the problem that it is space between instead of tab... best regards.

[Ex-jobb]

Hello GerdW!

Yes we have looked at "spreadsheet ..." but it did not fit for our wishes... but thank you for your answer.
Best regards.

[GerdW]

Hello Ex-jobb,

what do you want to change? There is no "Build Array" in the example...
And you can always change from tab to space as seperator like NeilR wrote and explained.

?-)

Best regards,
GerdW

[Ex-jobb]

Hello!

In the example above "string to array" in method 2 there is a build array. We would like to avoid the build array VI if it is possible.
Best regards.