From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

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! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
0 Kudos
Message 11 of 14
(901 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
(899 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! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
0 Kudos
Message 13 of 14
(894 Views)

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

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