How to search for empty cells in a specific column in a CSV file for all rows?
<p>Goal: Search through a specific single column in a CSV for empty rows only in that column and replace with string "No Box".</p>

<p>Attempts: So far I have tried to use CsvHelper and CsvTools(CsvReader) via Nuget C#. I am not very experienced with C# so not sure how to accomplish my task. Searching did not turn up any examples or references that helped me understand what I need to implement. There are a lot of similar questions, but none of them searched a specific column. I am hoping someone can provide me with advice on how to get my for loop to work and get the number of rows for my checking. </p>

<p>Image sample of my CSV file.
<a href="http://i.stack.imgur.com/hy9Vl.jpg" rel="nofollow">Sample of CSV data column Site</a></p>

<pre><code>private static void SiteBlanks()
{           
    try
    {
        MutableDataTable dt = DataAccess.DataTable.New.ReadCsv(@"C:\temp.csv");

        for (int i = 0; i &lt;= dt.Rows.Count; i++) // Cannot be applied to data types, so this errors.
        {
            if (!string.IsNullOrEmpty(dt.GetRow(i)["Site"])) // Check if cells in column 1 are empty
            {
                dt.Columns[1].Values[i] = "No Box"; // Update empty values with No Box

            }
        }
        dt.SaveCSV(@"C:\temp.csv"); // Save file after changes.
    }
    catch (Exception ex)
    {
        //Set Error message
        Error("ERROR: SiteBlanks()", ex);
    }
}
</code></pre>

<p>Note: This is my first question ever asked so be gentle and tell me what I may have did wrong posting wise.</p>