C#

 <br />
% 2 Dimensional array of numbers<br />
a=[1 2 3; 3 4 5; 6 7 8]<br />
aa=[1.1 2.2 3.3; 4.4 5.5 6.6; 7.7 8.8 9.9]<br />
% Single dimension string array (2D not permitted)<br />
b={'aaa0'; 'bbb0'; 'ccc0'}<br />
bb={'aaa0','aaa1'; 'bbb0', 'bbb1'; 'ccc0', 'ccc1'}<br />
<br />
c={'20100701' 1.11 2.22; '20100702' 3.33 4.44; '20100703' 5.55 6.66;}<br />
<br />
"c" above is cellarray 

        private string FixOBez()
        {
            SqlConnection dbconn = new SqlConnection(this.sqlconn);

            try
            {
                dbconn.Open();

                SqlDataReader sqlreader = null;
                SqlCommand mycmd = new SqlCommand("SELECT * FROM dbo.testdata", dbconn);
                sqlreader = mycmd.ExecuteReader();

                // Wo kein leerzeichen ist muss eins eingefügt werden
                while (sqlreader.Read())
                {
                    string obez = sqlreader["O_BEZ"].ToString();
                    string okuerzel = sqlreader["O_KURZ"].ToString();

                    // Neue Bezeichnung holen
                    string[] lines = GetNewOBez(obez);


                    // Neue Bezeichnung schreiben
                    SqlCommand sql2 = new SqlCommand("UPDATE dbo.testdata SET WEB_OBEZ1 = '" + lines[0] + "',WEB_OBEZ2 = '" + lines[1] + "',WEB_OBEZ3 = '" + lines[2] + "' WHERE O_KURZ = '" + okuerzel + "'",dbconn);
                    sql2.ExecuteNonQuery();

                    return "OK";
                }

            }
            catch (Exception ex)
            {
                return ex.Message;
            }

            return "OK";
}