static void Main(string[] args)
{
string sourcepath = args[0];
// there are a few static utility functions
Console.WriteLine("The given DAT file has {0} rows.", DelimitedFile.GetRowCount(sourcepath));
Console.WriteLine("The first row: {0}", DelimitedFile.GetFirstRow(sourcepath));
// initialize the reader, given the file to read from and that this file a header row
DelimitedFile file = new DelimitedFile(sourcepath, true);
// set delimiter values (these are the defaults)
file.NewlineCharacter = 10;
file.TextQualifierCharacter = 254;
file.CarriageReturnCharacter = 13;
file.ColumnDelimiterCharacter = 20;
// read in and handle an available line from the file
while (file.ReadRow())
{
if (file.CurrentRowNumber == 1)
{
Console.WriteLine("Column headers: {0}", string.Join(", ", file.CurrentRow.Columns));
continue;
}
else
{
if (file.SetColumnValue("text", "example"))
{
Console.WriteLine(file.GetColumnValue("text"));
}
}
}
}
public static DelimitedFileRow GetFirstRow(string p_path)
{
DelimitedFile file = new DelimitedFile(p_path);
if (file.ReadRow())
{
return(file.CurrentRow);
}
return(null);
}
public static int GetRowCount(string p_path, bool p_hasHeaders = true)
{
int rowCount = 0;
DelimitedFile file = new DelimitedFile(p_path, p_hasHeaders, true);
while (file.ReadRow())
{
rowCount++;
if (p_hasHeaders == true && file.CurrentRowNumber == 1)
{
rowCount--;
}
}
return(rowCount);
}
public static int GetRowCount(string p_path, bool p_hasHeaders = true)
{
int rowCount = 0;
DelimitedFile file = new DelimitedFile(p_path, p_hasHeaders, true);
while (file.ReadRow())
{
rowCount++;
if (p_hasHeaders == true && file.CurrentRowNumber == 1)
{
rowCount--;
}
}
return rowCount;
}
public static DelimitedFileRow GetFirstRow(string p_path)
{
DelimitedFile file = new DelimitedFile(p_path);
if (file.ReadRow())
{
return file.CurrentRow;
}
return null;
}