Need Split the data of my tab delimited file C#
<p>I need to split the text file (tab delimited) in columns and load in SQL Server. The problem is data in the file is not in a same manner there are spaces in columns like this:</p>

<pre><code>Name(Single Space)Sex(Multiple Spaces)Designation(Single Space)Salary(Multiple Spaces)
</code></pre>

<p>I am using following code to split the files but its not according to my need.</p>

<pre><code>for (int index = 2; index &lt; allLines.Length; index++)
{
    // split up the data line into its parts, using "|" as separator

    //string[] items = allLines[index].Split(new char[] { '\t' });
    string[] items = allLines[index].Split(new[] { '\t', '\n' });

    cmd.Parameters["@Name"].Value = items[0];
    cmd.Parameters["@GENDER"].Value = items[1];
    cmd.Parameters["@CITY"].Value = items[2];
    cmd.ExecuteNonQuery();
}
</code></pre>