LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to idenify comma as data in CSV file


@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

G# - Award winning reference based OOP for LV, for free! ADDQ VIPM Now on GitHub
"Only dead fish swim downstream" - "My life for Kudos!" - "Dumb people repeat old mistakes - smart ones create new ones."
Certified-LabVIEW-Developer
0 Kudos
Message 11 of 14
(81 Views)

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:

 

replace commas - FP.png

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?

Greets, Dave
Message 12 of 14
(79 Views)

@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

G# - Award winning reference based OOP for LV, for free! ADDQ VIPM Now on GitHub
"Only dead fish swim downstream" - "My life for Kudos!" - "Dumb people repeat old mistakes - smart ones create new ones."
Certified-LabVIEW-Developer
0 Kudos
Message 13 of 14
(74 Views)

That's right, but this wasn't the question of the thread opener (or hitchhiker).

Greets, Dave
0 Kudos
Message 14 of 14
(68 Views)