Removing "plus" symbol in Excel

[GerdW]

Hi Oesen,

there are a lot string functions in their own functions palette.

Ever tried to use them? 😉

[Oesen]

I dont write it as a spreadsheet. I use right click and "export to Excel" in the array in front panel

[GerdW]

Hi Oesen,

when using right-click you get what you see...

You should:

- learn to write files with all the functions provided by LabVIEW

- learn some basic rules of string formatting...

[Ray.R]

Ah... ok..

So if you leave everything as doubles as I suggested and use the Scan From String function to convert the measurement to a double, then you would not have the + or g.

 

But that won't allow you to add more columns.  You need to format everything to the appropriate type.  If you have columns which are strings, then most likely have everything conbverted to sting type.  Then you may be able to get away with using the Write to Spreadsheet String.  At least that is the simpler way.

[Ray.R]

Did I not post this? :

To learn more about LabVIEW, I suggest you try looking at some of these tutorials.

[Oesen]

Hmmm . How do i implement that "Scan from string" in my code ?.  What should i write in the "format string" part ?

[GerdW]

Hi Oesen,

there's an excellent help for all the format codes. You may try "%s%f" in the first shot...

[Oesen]

Yes, but i have to get rid of the "+" symbol first of all. So i must write something different ?

[GerdW]

Hi Oesen,

as long as the string received from device is similar to your example (with spaces between sign and number) my suggestion should be ok.

Did you read the help (as recommended) by now?

[Ray.R]

You can also post the code that you have so far...