topic Re: Problem openning file with 9 spaces separation between columns... help! in LabVIEW

Problem openning file with 9 spaces separation between columns... help!

Fonsi — Tue, 31 May 2005 15:04:34 GMT

Hi,

I am trying to open one file with 2 columns, the problems is the columns is separate with 9 spaces of caracter and i dont know what put in the delimiter option...

Any help?.

Regards, Fonsi.

Re: Problem openning file with 9 spaces separation between columns... help!

Fonsi — Tue, 31 May 2005 15:05:04 GMT

Re: Problem openning file with 9 spaces separation between columns... help!

Fonsi — Tue, 31 May 2005 15:06:07 GMT

Re: Problem openning file with 9 spaces separation between columns... help!

Evan — Tue, 31 May 2005 15:09:00 GMT

You are on the right track and your code is close.

The first thing to do is right click on the string control and change it to '\' Codes Display

Notice your delimiter is \s\\s, which I doubt is in your file. You are correct that \s is a space, however that is only valid in the \ code display. So your delimiter is a space followed by a true "\" character followed by an "s"

So you have 2 options to create a 9 space delimiter. In slash codes display type in \s\s\s\s\s\s\s\s\s or in the normal view just hit the space bar 9 times.

Re: Problem openning file with 9 spaces separation between columns... help!

Fonsi — Tue, 31 May 2005 16:11:43 GMT

yes, thanks.
But the problem is sometimes the spaces are 9 another time are 10.
Any way to get it?.
Regards,Fonsi

Re: Problem openning file with 9 spaces separation between columns... help!

Evan — Tue, 31 May 2005 16:32:09 GMT

If you are not sure how many spaces there will be between values I would try something different. Here is a VI that takes a string and converts it over for you. I simple replace all groups of spaces with a tab control and then use the Spreed Sheet string to Array VI.

So read your file in as a string and feed it through this example code.

Re: Problem openning file with 9 spaces separation between columns... help!

Fonsi — Tue, 31 May 2005 19:46:20 GMT

Thank you, very much.
I got it.

Regards, fonsi

Re: Problem openning file with 9 spaces separation between columns... help!

altenbach — Tue, 31 May 2005 21:26:36 GMT

Personally, I prefer the "scan strings for tokens", because it skips empty tokens and thus any consecutive sequence of separators are treated as a single separator (what if somebody manually edits the file and replaces a few spaces with tabs?).

Have a look at my old example from this thread . (Also have a look at the slighly more complex version in my last post of the quoted thread).

Re: Problem openning file with 9 spaces separation between columns... help!

Fonsi — Tue, 31 May 2005 21:33:13 GMT

altenbach, thanks!.

Runs well too.

In my case, always is the same spaces, since is got from the output of soft, and i get this file to draw in my application...

Regards

Re: Problem openning file with 9 spaces separation between columns... help!

altenbach — Tue, 31 May 2005 21:49:31 GMT

@Fonsi wrote:
In my case, always is the same spaces, since is got from the output of soft, and i get this file to draw in my application...

Are you sure about that? In the image you posted above, the number of spaces seems to changes at 10000 and above.

Re: Problem openning file with 9 spaces separation between columns... help!

Fonsi — Wed, 01 Jun 2005 07:47:55 GMT

Yes, you are right!.

Always get 10 spaces and later over 10000 get 9. Since the data is the minimal 1000 and never over 20000, only are 10 and later 9. But curioustly i put constant tab of 9 spaces and the data is ok!!. I dont know why but its runs....
Althought the others vi works perfectly too...
Regards, Fonsi.

Re: Problem openning file with 9 spaces separation between columns... help!

Diego_M — Wed, 01 Jun 2005 14:13:14 GMT

Hi Fonsi,

NI has got an example code on web page about how to convert a Space-Delimited File to Tab-Delimited (Spreadsheet) Format

This is the link

http://sine.ni.com/apps/we/niepd_web_display.display_epd4?p_guid=B123AE0CBB0F111EE034080020E74861&p_node=DZ52027&p_source=External

Likewise I have attached the vi

Regards

Diego M.