02-19-2019 05:49 AM
@daveTW wrote:
So I try to fry this little fish...
What if a number doesn't have a comma? If it's set to "hide trailing zeros"?
/Y
02-19-2019 06:32 AM - edited 02-19-2019 06:33 AM
All delimited data which doesn't match this criteria remain untouched. The criteria is:
Between 2 double-quotations must be one (or more) figures, followed by a comma, followed by one (ore more) figures.
In the attached VI the input string is defaulted with sample data. It is shown in the following:
As you can see, the comma between letters is ignored and two commas are ignored too (third line).
P.S. Did I understand your question correctly?
02-19-2019 06:58 AM
@daveTW wrote:
P.S. Did I understand your question correctly?
Close enough. I was thinking of "3,14","7","1,7172","9"
It looked like it would only modify some, yes, so what happens in the next step when you use Spreadsheet string to number array?
/Y
02-19-2019 09:11 AM
That's right, but this wasn't the question of the thread opener (or hitchhiker).