strSplitConnectString

strSplitConnectString(
  const connstr,      // connect-string
  [var& password,     // extension
   var& connection,   // directory
   var& database])    // drive

Splits a connect string into its 4 parts database, userid,password and connection. The connect-string has the following syntax:

  [database:][userid][/password][@connection]

Any of the 4 parts may be missing. The database-part is converted to uppercase; the other parts are left in original case.

Returns the userid.

Example:

var db, name, pass, conn;
name = strSplitConnectString(
         'db2:Sandra/Bullock@Hollywood',
         pass, conn, db);
       // db   = 'DB2'
       // name = 'Sandra'
       // pass = 'Bullock'
       // conn = 'Hollywood'