spreadsheet string to array

[MarkDavid]

Can anyone tell me why the 1st element  (zero) is empty??  Why isn't it OFF_1 ???? 

[MarkDavid]

Once again..duh...here is the vi

[RavensFan · Accepted solution]

Because you have the delimiter "L" at the very beginning of your string.  No other characters exist before that, so you get the empty string as your zeroth element.

If you didn't have the "L" at the beginning, then "Off_1" would be your zeroth element.

PS:  You can edit your message within 10 minutes of when you first posted it by going to the options menu to the right.  You don't have to create a new message in order to add the attachment.

[MarkDavid]

So it looks for the characters before ( hence delimiter) the delimiter.   My bad...thanks.  Sometimes I can't see the forest throught the trees.

[MarkDavid]

Sometimes I can't spell either.

[RavensFan]

Yes, the delimiter is for the character that separates elements.  So it is looking for data ahead of that first delimiter, and there is no data there.

Then please mark my message #3 as the solution to your question.  You can unmark your message #4 by going to the options menu to the right of the message.