wordpad vs. microsoft excel

[krispiekream]

hi there. i was wondering if someone have an explanation for me.

i have this vi. it move data to file by serial number.

i have one question. how come when i open it with excel. i dont see the wierd characters as I do when i open it in wordpad.

is it WINDOWS or it is something i can fix in my labview program to get rid of that?

 

Message Edited by krispiekream on 08-27-2008 04:59 PM

[smercurio_fc]

Well, since your VI is not changing the string that was read, then those NULL characters (which is what those are) would have to be coming from the original file.

Note:  You could just use the Copy file I/O function.

[krispiekream]

. great thanks. i'll try that

have a great labor day weekend

[krispiekream]

ok, i just got back from vacation.

i tried looking up copy file I/O function but i dont see it anywhere.

can you tell me how to get that.

i am using labview 7.0

thanks

[smercurio_fc]

It's in the Advanced File Functions palette. Remember there's a Search for the functions palette.

 

Message Edited by smercurio_fc on 09-03-2008 01:50 PM

[krispiekream]

sorry, this is a really silly question, but what do i replace the copy function with?

Message Edited by krispiekream on 09-03-2008 03:19 PM

[altenbach]

Well, it really depends on your data. You are reading a file line-by-line, and for each recond you append to a file with a certain file name based on a value in the current record.

You would only be able to use "copy" if all serial numbers in the input file are the same, and maybe they are not.

[krispiekream]

---

Well, it really depends on your data. You are reading a file line-by-line, and for each recond you append to a file with a certain file name based on a value in the current record.

You would only be able to use "copy" if all serial numbers in the input file are the same, and maybe they are not.

---

yeah. all the serial numbers in the input file are NOT the same.

so there is no other way to fix this?

can i say that all the NULL characters are due to how WORDPAD?

[altenbach]

NO, your null characters are part of the original file. Excel just suppresses them in the display, which does not mean they are not there. You can eliminate them with some code if you want before writing to the output file.

A few more hints:

• Never use "string to path" and "path to string", use strip path and build path exclusively.
• Since you are only processing one line, use a 1D array as type for the "spreadsheet string to array" and then take element 14.

[krispiekream]

I don't understand this part.

"Since you are only processing one line, use a 1D array as type for the "spreadsheet string to array" and then take element 14." can you show me through a diagram?

sorry..