Removing "plus" symbol in Excel

[Oesen]

Ok.. I can't test my VI now, but i just implementet the "scan from string" box in my VI

[Ray.R]

You completely missed what I was trying to explain...

Let's see if I can rewrite what you did and show you an example of what I tried to explain...

[Ray.R]

Here is a snippet of what I meant:

 

[Oesen]

I have tried your solution, and thanks for the help, but the array doesnt show any decimal number in the measurement part ?. I want two decimal numbers, how to do that ?

[Ray.R]

I'm not sure what you mean because it should work with decimals. See image below:

 

And it works even if there are no spaces:

+35.24g 

will give

35.24

[GerdW]

Hi Oesen,

did you read the context help as recommended?

Did you try the format string "%s%.;%f" after reading the context help carefully?

[Ray.R]

Hi Gerd,

Did I miss something?  Why "%s%.;%f"?

Does the OP want to conserve the + sign and save it into the spreadsheet?

If so, then using the indicator to export to the spreadsheet file may not do what the OP wants.

I must be missing something...  😞

[GerdW]

Hi Ray,

the OP said (s)he was missing "decimal numbers" (fractional part of the number). So I guess the computer the VI is running on is using a different decimal separator and thus included "%.;" in the format string to assure proper conversion of the value in the device string...

[Ray.R]

Ah...  I didn't think of that one.

Thanks!

[Oesen]

Thanks for the help guys. I wrote '%.;%f' in the format string box, and everything works fine now 🙂