Importing raw market data

[akif]

I dont know where this fits, but the problem is urgent, and am hoping someone can help me out of this one

I have access to the message formats for a stock exchange, and basically the stock exchange transmits data in tab separated format. Now if im getting the broadcast from the exchange, how can I 'decipher' the incoming broadcast, so it would display all the market data in a tabular format, eg in Excel?

I believe its quite simple, but for a newbie like me, Id appreciate a walk through.

Thanks in advance.

[PeejAvery]

Basically you have a csv file but it separated by tabs instead? If this is the case, you can use almost any programming language to read and parse it. All you would have to do is read the file into a string. Replace all tabs with a comma and then open it into Excel.

Note: Tabs are hidden characters usually expressed by \t.

[MrViggy]

Well, you can also import tab seperated files into Excel. As long as the file's extension is .txt; Excel will "assume" that the cell delimiters are the tab characters.

Viggy