Re : Simple problem writing "#N/A" to a .txt file

[marc france]

Hi,

I would like to write the string : #N/A in a text file so that when I open the text file whith Excel, those points don't appear on the plot. Whith the VI I have attached, those #N/A points are considered as 0 on the excel plot. Whereas if I write #N/A directly into excel (without using Labview) it works fine. I have only noticed that going through my program "#N/A" apperas on the left of the cell in excel, whereas when entered directly it is centered. I suppose I am using a wrong format or something like that but I can't find the solution. 

Anyhelp would be great,

XP & 8.5

Regards,

Marc

[smercurio_fc]

You have a space before and after the "#N/A" text. Remove them and it should work.

[jcarmody]

Just for kicks, try putting a single quote before the #N/A in the string constant. 

The single quote makes Excel consider it a text entry the way you get when you type it in.

Jim

[marc france]

Hi Smercurio and JCarmody,

First thank you for answering my question.

1°)Concerning Smercurio, deleating the space before #N/A in the text file makes it work. But I would like to avoid doing this each time, and just being able to write directly the correct expression from Labview.

2°)Concerning JCarmody, I had already tried putting eather  " or ' signs before #N/A in Labview, and making sure I am ticking the correct option in Excel when I open the .txt file, but this doesn't work. I get "#N/A or '#N/A in the cell, but it is still consired as 0 on the plot.

Regards,

Marc

[Steve__M.]

Hi Marc,

Have you try to open your text file with Excel 2007 ? what version do you have ?

Regards,

[marc france]

Hi Steve,

I am opening the text file with Excel 2000.

Marc

[Steve__M.]

Do you open your .txt with the Excel Text Import Wizard ? See here to use it efficiently http://www.robelle.com/tips/st-export-excel.html

http://www.uic.edu/depts/accc/seminars/excel2000-intermed/import.html

also I invite you tu use this tool  http://www.beside.com/index.html

I hope it helps.

Regards,

[Dennis_Knutson]

If you want to create the correct string in LabVIEW, you should use the Format Into String correctly. All of the concantanation is totally unneccesary. Wire the date and time into it and use a format string of "%s\s%s\t#N/A\r\n" with '\' Codes Display turned on.

[marc france]

Hi Dennis, Your solution works fine thanks. My text value can either be a numeric value converted to text or #N/A when I don't get any value from my instrument. Does this mean I have to use a  condition structure where I have 2 possibilities (see attached VI that works) : 1) My value is #N/A, I use a format to string Icon, whith the format "%s\s%s\t#N/A\r\n"2) my value is 35 for instance (in a string format), I use a format to string Icon, with the format "%s\s%s\t%s\r\n" and I wire my value to the correct entry of the format to string icon 

Is this correct, or is there a simpler way to reach my purpose?

Marc

[Dennis_Knutson · Accepted solution]

I would use the Select function and a single Format Into String function.

Message Edited by Dennis Knutson on 11-07-2008 08:02 AM