wordpad vs. microsoft excel

[altenbach]

Your "spreadsheet string to array" has a 2D array constant as type. Simply make this a 1D array by resizing the index terminal so only one index shows to turn it into a 1D array. Now the output is a 1D array where you simply can take element #14.

See if this works for you.

[krispiekream]

i think i am doing this right.

i replaced string to path with "strip path"

and           path to string with "build string"

but i am getting "Open File error" if i do this.  

 

Message Edited by Support on 09-04-2008 08:48 AM

[smercurio_fc]

altenbach wasn't implying to use both Strip Path and Build Path for your code, but that they should generally be used instead of making paths using strings. In your case you only need Build Path. Wire the "dest path" control to the "base path" terminal of Build Path and the output of your Concatenate String function to the "name or relative path" input terminal of Build Path.

Message Edited by smercurio_fc on 09-03-2008 05:51 PM

[altenbach]

PLEASE keep your images to a reasonable size! Crop it to the important information!

Here's what I had in mind.

Message Edited by altenbach on 09-03-2008 04:00 PM

[krispiekream]

u mean like this?

[krispiekream]

ok. that works.

but it look like i have to go all the way back to the program to find out where/when/why the NULL characters are being saved. 

thank you so much guys!

[krispiekream]

ok. i think i found out where the program was creating those NULL CHARACTERS.

its the FALSE case. 

everytime its FALSE...the "EMPTY STRING CONSTANTS" is being written in the file and those characters are NULL.

does anyone have any suggestion?

i want to get rid of them. what can i put in the false case that would be NOTHING....

i'll attach the write_data.vi

[altenbach]

This is because you are writing an array of strings. THe "prepend array or string size=False" controls only the toplevel structure, i.e. the array size, so your array elements that are empty strings with have zero size and thus contain a few nulls.

Try the following: Insert a size=1 "concatenate strings" into the string array right before you write it to the file. This will make it a plain string. 

[RavensFan]

The problem is related to autoindexing.  If you run a loop X number of times with an autoindexing output tunnel, then it creates an array with X items.  Every item in the string array has to contain something.

I don't know how this VI you posted fits in with the rest of your code as it looks like a stripped down example.  I think you have 2 choices.

1.  Search the array for strings with a 255 character and delete them from the array before writing it out to the file.

2.  Don't use autoindexing.  Use a shift register that builds upon and concatenates new data to the string in the shift register every iteration in the true cases.  In the false cases, you wire through the string as is.

[krispiekream]

cool.. this works...

---

Try the following: Insert a size=1 "concatenate strings" into the string array right before you write it to the file. This will make it a plain string. 

---

thank you guys. great advices and without you guys help. i think think i'll never find the solution

thanks again

smercurio_fc, altenbach, and Ravens Fan