Removing first character from a column if it starts with 0
<p>I have an oracle table, <code>a_abc</code> that have three columns (<code>name</code>, <code>ID</code> and <code>address</code>). The data for this table will be extracted from a txt file. How to remove the first character in ID column if it starts with number '0'. I need a VB solution. This is what Ive done so far now</p>

<pre><code>Private Sub ReadData()
    Dim rowvalue As String
    Dim cellvalue(20) As String
    Dim header As String = "ID"
    Dim streamReader As IO.StreamReader = New IO.StreamReader("D:\local_costctr.txt")
    'Reading CSV file content 
    While streamReader.Peek() &lt;&gt; -1
        rowvalue = streamReader.ReadLine()
        cellvalue = rowvalue.Split("|") 'check what is ur separator

        ConnectOracle()
        mySQLcmd.Connection = myConn

        If SQL.Length &gt; 0 Then
            SQL.Replace(SQL.ToString, "")
        End If

        SQL.Append("insert into a_abc (name ,ID ,address)  ")
        SQL.Append(" values ('" &amp; cellvalue(0) &amp; "' ,'" &amp; cellvalue(1) &amp; "','" &amp; cellvalue(2) &amp; "') ")


        Console.WriteLine(header)
        Console.WriteLine(header.Trim({"0"c}))          


        Try
            mySQLcmd.CommandText = SQL.ToString
            mySQLcmd.ExecuteNonQuery()

        Catch ex As Exception
            MessageBox.Show("Error " &amp; ex.Message.ToString)
        End Try

    End While
End Sub
</code></pre>

<p>If there is more than one leading zero, I want all of them removed.</p>