Array To Spreadsheet String, Empty Delimiter

[aschipfl]

The Array To Spreadsheet String function does not accept an empty Delimiter, it uses the Tab character in such case.

The same is true for the Spreadsheet String To Array function (but of course this function cannot work without a Delimiter).

I would appreciate one of the following options:

• to allow an empty separator for both functions (for Array To Spreadsheet String this can easily work obviously; for Spreadsheet String To Array you might see an empty string delimiter between each two adjacent characters similar to the Search and Replace String function with an empty search string);
• to document that behaviour properly;

I would prefer the first option espacially for the Array To Spreadsheet String function. What do you think?

[johnsold]

What should the output string look like if you do not have a delimiter? 

Rather than create a special case for the Array to Spreadsheet String function, it appears that you could use a for loop and Concatenate Strings with a shift register. If you do this often, create a subVI.

Lynn

[GerdW]

Hi aschipfl,

some thoughts about your suggestion:

- When you want to suggest improvements to LabVIEW you should post in the Idea Exchange.

- NI will not change the behaviour of functions existing for a long time…

- NI will probably update the LabVIEW help for that function…

- a spreadsheet string needs some kind of delimiter, what's the purpose of creating a spreadsheet string without them?

When you really need a "Array to Spreadsheet String" without delimiters you could take this approach:

[mikeporter]

Your post makes no sense. You are talking about turning the array to spreadsheet function into concatenate string -- which already exists. If you want to simply concatenate the strings in the array then do so. Concatenating is a different function form formatting.

Oh and the function is documented correctly.

Mike...

[aschipfl]

Hi Mike,

the documentation is not clear concerning empty delimiter (at least in LabVIEW 2013).

It says that the default is Tab, but auto-replacing an empty delimiter string by Tab is not mentioned.

Cheers

[altenbach · Accepted solution]

---

@aschipfl wrote:

The Array To Spreadsheet String function does not accept an empty Delimiter, it uses the Tab character in such case.

---

This is an old story covered in my idea here. (from 2009!)

If there is more insight, it should be added as a comment to the quoted idea.

Let's keep the discussion all in one place! Thanks.