Re: How to add a missing character value

[Dennis Knutson]

There's a couple things you might try. Before you do the Spreadsheet
String to Array, if your spreadsheet string is something like
1.1,,2.3, then you could do a search and replace of ,, and stick in
some number you wouldn't normally see or NaN (Not a Number). You could
also first create a string array with Spreadsheet String to Array and
search the array for an empty string and replace those values before
doing the conversion to a numeric array.