Publisher review:DatabaseCell2Mat converts the cell matrix that the Database Toolbox provides into a numeric matrix and a structure. DATABASECELL2MAT converts the cell matrix that the Database Toolbox provides into a numeric matrix and a structure. The fieldnames of the structure will be the same as the column names of the tables.It converts date/time types into MATLAB julians and bit types into 1s and 0s.Without this utility, dates would be in string format not compatible with datenum and the bit types would be "true" or "false".CAVEATS:Times are ignoredStrings are not handled.INPUTS:Cellstring matrixTable attributesUSAGE:c=database('mydb','','');query=['SELECT * FROM mytable;'];curs=exec(c,query);curs=fetch(curs);[mat,s]=DatabaseCell2Mat(curs.Data,attr(curs));close(c);>> curs.data(1:4,:)[4.2][1x21 char][-13.3][ 1.8][ 6.4][-7.9][-24.7][1x21 char] 'false'[5.5][1x21 char][ -4.7][ 6.8][11.7][-1.8][-17.2][1x21 char] 'false'[ 4][1x21 char][ -7.3][ 2.3][ 7.2][-3.7][-17.1][1x21 char] 'false'[5.7][1x21 char][ -6.6][-0.3][ 9.4][-1.6][ -16][1x21 char] 'false'>> curs.data(1:4,2)'2003-03-31 00:00:00.0''2003-03-31 00:00:00.0''2003-04-30 00:00:00.0''2003-04-30 00:00:00.0'>> mat(1:4,:)1.0e 005 *0.0000 7.3167 -0.0001 0.0000 0.0001 -0.0001 -0.0002 7.3164 00.0001 7.3167 -0.0000 0.0001 0.0001 -0.0000 -0.0002 7.3164 00.0000 7.3170 -0.0001 0.0000 0.0001 -0.0000 -0.0002 7.3164 00.0001 7.3170 -0.0001 -0.0000 0.0001 -0.0000 -0.0002 7.3164 0>> sCoupon: [13215x1 double]Maturity: [13215x1 double]Axx_Spd: [13215x1 double]AX_COD: [13215x1 double]AX_100dMax: [13215x1 double]AX_100dAvg: [13215x1 double]AX_100dMin: [13215x1 double]AX_Date: [13215x1 double]Current: [13215x1 double] Requirements: · MATLAB Release: R13 · Database Toolbox
DatabaseCell2Mat is a Matlab script for Scientific/Engineering scripts design by Michael Robbins.
It runs on following operating system: Windows / Linux / Mac OS / BSD / Solaris.
Operating system:Windows / Linux / Mac OS / BSD / Solaris
DatabaseCell2Mat script details 
