LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Extra Character and Line in String Spreadsheet read

Solved!
Go to solution

Hi All

 

I've tried to look, but no clue yet. I am using labview 7.1 and trying to read a spreadsheet string file into a string array, but i got extra character in the beginning of the file and extra line in each of the line. I Have tried to put a value in the pos offset, can solve the extra character problem, but it didn't feel right.Text file, source code and result attached. Can Anybody explain about this?

Thanks A lot.

 

-Just a student-
0 Kudos
Message 1 of 5
(3,163 Views)

Hi Nandha,

can you upload your files? Try also the "Read From Spreadsheet File" function.

 

Mike

0 Kudos
Message 2 of 5
(3,152 Views)

These are my files.

The "Read from spreadsheet" function is only applicable for reading numbers, not string.

That is why first i tried to read the file as string, and then split it using "spreadsheet string to array".

My goal is to make an array of strings.

Thanks

 

 

-Just a student-
Download All
0 Kudos
Message 3 of 5
(3,143 Views)
Solution
Accepted by topic author Nandha

Hi Nandha,

your file contains this additional characters (i think it's a unicode file), but the normal editor don't show them. You can see them if you open your file with Word.

 

Mike

Message 4 of 5
(3,139 Views)

OMG, i didn't realize that

Thanks a lot, Tried to open it from word as plain text, and it did contain the extra character and extra line. Actually i made the text using excel and save it as semicolon delimited, And that is the result.

 

Once again thanks a lot. Kudos for you.

-Just a student-
0 Kudos
Message 5 of 5
(3,135 Views)