how to import data queried from a database separated by commas

1 view
Skip to first unread message

ruk

unread,
Aug 7, 2009, 5:38:36 AM8/7/09
to MATLAB Pool
I'm currently working on a large database on which I run queries and
then analyze and plot the results of the queries. I run the queries on
a web browser, it is an online database, and the results are bigint,
int, or real. The result of the query, a specific row of about 20000
rows, would look something like this:

2510,0,63000000000000,2,3600.9878,6.673644,13.117046,25.416761,16.91994,74.19226,-586.47437,63,1.5714737


Each data, separated by a comma, belongs to a column. There are a
total of 13 columns. I need to plot data, in say an x-y plot, of say
column 8 (x) and column 9(y) . What would be the best way to do this
in matlab? How effectively would dlmread work? I haven't used dlmread
before. I store the data usually as a .txt file

dr.med.rasen

unread,
Sep 1, 2009, 5:06:37 AM9/1/09
to MATLAB Pool
i dont know if it will work with databases, but ive tried it
using .txt files. csvread imports data seperated by ','

good luck

On 7 Aug., 11:38, ruk <ruk...@gmail.com> wrote:
> I'm currently working on a large database on which I run queries and
> then analyze and plot the results of the queries. I run the queries on
> a web browser, it is an online database, and the results are bigint,
> int, or real. The result of the query, a specific row of about 20000
> rows, would look something like this:
>
> 2510,0,63000000000000,2,3600.9878,6.673644,13.117046,25.416761,16.91994,74.­19226,-586.47437,63,1.5714737
Reply all
Reply to author
Forward
0 new messages