Removing "plus" symbol in Excel

[Oesen]

Hello dear Labviewers. I need to calculate the values in excel, and can't do that with those "plus" symbols. Is there any way to remove them from Excel ?. The problem occurs because my scale can measure both positive and negative values in grams.

[GerdW]

Hi Oesen,

it seems you send strings to the Excel sheet. You have to convert those into numbers, either in LabVIEW or in Excel...

[Oesen]

So i need to convert the string into a number before the array in the block diagram of my VI ?

[GerdW]

Hi Oesen,

atleast you should remove the "+" as well as the unit ("g") from your string delivered by the measurement device.

Excel doesn't recognize a string like "+ 123.4 g" as a number, instead it formats that as a string - and Excel can't calculate with strings!

Btw. is there a reason to compare boolean values for "equal to TRUE"??? You should also search for "Rube Goldberg" in the forum 😄

[Oesen]

Thanks for helping GerdW.

I have converted to a number, but the layout of the excel document isn't as good as before.

Can i make a headline for both time and measurement columns in excel, and how do i do that ?

[Ray.R]

something does not look quite right...

You are cvonverting a double to string, then back to an array of doubles..

Can you show the rest of your code (or post it)?

And you can add more columns..  Your image does not show what you write to file..  or Excel..  or Spreadsheet file...

[Oesen]

Here is my VI 🙂

[GerdW]

Hi Oesen,

you still don't show a VI where those data are actually saved to a file...

I also wrote

---

atleast you should remove the "+" as well as the unit ("g") from your string delivered by the measurement device.

---

but you didn't follow that suggestion...

[Ray.R]

Curious:  Is this program for the visually impared?  Or for a monitor that is far - far away from the operator?

Just asking because it is super large...  😉

I did not see where you write the values to the Excel spreadsheet.  It must be in a different VI.

But I do have comments for the one you posted.  Nothing serious, just things you pick up with experience..

Also, you do realize that you need to select the Start/Stop and / or  Reset before you click on Measurement 4 so that they do the proper action, right?

I think you may need to investigate producer consumer architecture.

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

[Oesen]

Hi GerdW

How do i remove "g" and "+" from the string ?. The command from the scale writes automatically those two values as a string.