Opening .txt file - Need another set of eyes

[DonRoth]

Hi folks - The attached file opens in Notepad and MS Excel as 9999 rows x 3 columns (X,Y,Z values, respectively).  I have tried different delimiters using 'Read From Spreadsheet File.vi' to bring in all the data but only successful bringing in the first column of 9999 values.  Can someone take a look at this and give me the trickto get it open using LabVIEW?  I expect it is something very simple but it is a Monday, isn't it?

Thanks in advance.

Don

[elset191]

The delimiter is a space (\s)

Message Edited by elset191 on 11-16-2009 11:31 AM

[CAC10268]

This is all you should need to do...

-CAC

[elset191 · Accepted solution]

Make sure you select '\' Codes Display.  otherwise it's actually \\s which is nothing. Additionally you could just use the space constant like the person above this post did.

[DonRoth]

...Bitten again by the syntax for 'Space Constant'!  Here is the easiest way:

Thanks for looking at this.  I knew it had to be simple - I was using \s for space delimiter and it will not work as mentioned above unless 'codes display' is selected (which I did overlook).

Don

Message Edited by DonRoth on 11-16-2009 12:06 PM

[elset191]

---

Thanks for looking at this.  I knew it had to be simple - I was using \s for space delimiter and it will not work.

---

\s works.  See my post right before yours

[DonRoth]

I was in the middle of correcting the post when you replied....thanks again, Don

[PhillipBrooks]

If you've ever been burned by this before, please kudo altenbach's Idea Exchange submission...

Indicate the display format of Strings

[DonRoth]

I have done so.  It is a good idea.  I normally work with binary files but it is remarkable how about every 2 years when a text file comes my way, I forget about this one....Don