format text file from internet

[km76107]

I need to format a text file data that is generated in VB and displayed in a webpage address (http://192.xxx.xxx.xx/data.txt). The data looks garbled right now and I need to make it appear in some readable form (tables, spreadsheet etc).  I dont have access to the VB file or the webserver that ports the data to Port 80.

 Is there a way to format this text file?

Any help is appreciated.

Thanks in advance.

kmoorthy

[altenbach]

Why don't you attach a sample text file you we know what you are talking about. "Garbled" is not a very specific description. 😉 

[km76107]

Hi Altenbach,

Please see attached file.  My intention is to make the data reader-friendly.  Thats what I mean by garbled.  The data makes sense now, but its just haphazard.

This is my approach to the issue and please correct me if I am doing it wrong... I am grabbing the data from the URL using Datasocket as a string and then using the string to array function to format it.  Then I intend to use the webserver and display the formatted data on a different URL.  Does this make sense or am I lost?

Thanks

[km76107]

Oops.. Sorry I forgot the file.  Here u go...

[altenbach]

A table seems fine. Here's one example (LabVIEw 7.1) to do this (assuming 23 columns). It is a little wide,so the table needs to be scrolled horizontally. You might want to only select a few interesting columns for display.

Let me know if anything is not clear. 🙂

[km76107]

Hi Altenbach.

Thanks for the response.  I am not sure where did the number 32 come from? I am trying to split the data in such a way that the header "date" has all the dates (7/21/05) in the following rows and the header "time" has its corresponding entries in the subsequent rows and so on..

Thanks

KM

[altenbach]

Well, the "32" was just a wild guess, you can choose any number you like until it looks right. (any other number does not quite look right to me, though)

You can take my example as a start, then slice out the interesting columns further and arrange or parse things anyway you want. I cannot know what you want! ;).

[km76107]

Thanks altenbach. It makes sense now.  I appreciate your help.

KM