DatabaseCell2Mat Matlab script

SPONSORED LINKS

    Specification

  • Version:
  • File size: 0 KB
  • File name: DatabaseCell2Mat.m
  • Last update:
  • Platform: Windows / Linux / Mac OS / BSD / Solaris
  • Language: Matlab
  • Price:Freeware
  • Company: Michael Robbins (View more)

DatabaseCell2Mat script description:




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

Latest script and internet news

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

The new Firefox 37 comes with improved HTTP / 2 and superior HMTL5 compatibility with YouTube

The popular browser Firefox reached version 37, bringing a series of news but not as significant as other versions.

Posted on: 03 Apr 2015 11:11 by A. Brown

The permanently active Push system offered by the new Google Chrome 42

The permanently active Push system offered by the new Google Chrome 42

Google Chrome version 42 comes with implementation of interesting options for software developers who want to turn their websites into complex Web applications: Push notification system which is permanently active.

Posted on: 17 Mar 2015 07:57 by A. Brown

Gamers, Microsoft presents the advantages of DirectX 12 and 11.3 platforms used by new games for Windows 10

Gamers, Microsoft presents the advantages  of DirectX 12 and 11.3 platforms used by new games for Windows 10

The Windows 10 preview event brought also to the attention of gamers a demonstration of the advantages of the new DirectX 12 API by Microsoft, which announced several technologies providing integration with Xbox One game consoles.

Posted on: 27 Jan 2015 09:15 by A. Brown

Android devices now have access to Google Chrome 40

Android devices now have access to Google Chrome 40

Finally was officially released version 40 of Chrome browser for Android devices, iOS and Windows PCs, coming up with an interesting range of bug fixes and optimizations.

Posted on: 23 Jan 2015 13:57 by A. Brown

SPREAD THE WORD

User Rating


Rating: 3.0 out of 5
Based on 1 ratings. 1 user reviews.

  • Currently 3.00 out of 5
  • 1
  • 2
  • 3
  • 4
  • 5