Our online shopping is experiencing intermittent service disruptions.
Support teams are actively working on the resolution.
Our online shopping is experiencing intermittent service disruptions.
Support teams are actively working on the resolution.
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).