How to Use Shouldskiprecord in Csvhelper
I Have a Csv File and I Am Using Csvhelper to Read the Csv File. the First Row Is Header. Rowid Name --> 0The Row ----- ---- 1 John 2 Smith 3 Mark 4 Tom I...
I have a csv file and i am using csvhelper to read the csv file. The first row is header.
RowId Name --> 0the row
----- ----
1 John
2 Smith
3 Mark
4 Tom
I dont know how to use ShouldSkipRecord for this purpose. How can I directly jump into RowId 3 using CSVHelper ? [do NOT remove header] and starts read from rowid 4 onwards ??
This is what i did.
CsvConfiguration csvConfiguration = new CsvConfiguration(CultureInfo.InvariantCulture)
{
HasHeaderRecord = true,
Delimiter = ",",
PrepareHeaderForMatch = args => args.Header.ToUpper(),
IgnoreBlankLines = true,
IgnoreReferences = true,
MissingFieldFound = null,
UseNewObjectForNullReferenceMembers = true,
ShouldSkipRecord = row => Convert.ToInt32(row.Row[MyPoint].Skip(0)) <= MyPoint
}; // Mypoint = 3
CsvReader csv = new CsvReader(File.OpenText(FileNameWithPath), csvConfiguration);
csv.Read();
csv.ReadHeader();
while (csv.Read())
{......}
1 Answer
Your ShouldSkip method needs more logic as it needs to deal with the header, the separator and the RowId values. The method needs to return correctly true of false for all of these situations.
Here is one approach to fulfill the requirements:
// row holds an array of string values of each column in the current row
bool ShouldSkipHandler(string[] row)
{
var rowIdCol = 0;
// sanitize columnValue
var currentRowId = row[rowIdCol].Trim();
// is this the header?
if (currentRowId == "RowId") {
return false;
}
// is this the separator
if (currentRowId.All( c => c == '-')) {
return true;
}
// is this a Rowid
int rowId;
if (Int32.TryParse(currentRowId, out rowId)) {
// is the rowId less than 4?
return rowId < 4;
}
return true;
}
When put into this test rig:
var sr = new StringReader(@"RowId , Name
----- , ----
1 , John
2 , Smith
3 , Mark
4 , Tom
");
var csvConfiguration = new CsvHelper.Configuration.CsvConfiguration
{
HasHeaderRecord = true,
Delimiter = ",",
ShouldSkipRecord = ShouldSkipHandler
};
CsvReader csv = new CsvReader(sr, csvConfiguration);
csv.ReadHeader();
while (csv.Read())
{
csv[0].Dump(csv.FieldHeaders[0]); // LinqPad
}
and run in LinqPad, this is the result:
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
