All Questions
11 questions
0
votes
0
answers
45
views
CSVReader TryGetField Unescaped Quote
I am using CsvReader to parse a string similar to
var dataToParse = "US"|"10"|"0"|"0"|"45.0"|"1.0"|"Product is 1""|"1.65&...
- 521
-1
votes
1
answer
227
views
CsvHelper.CsvReader won't read CSV file
first things first, my program is supposed to append the contents of a CSV file to an SQL table in SQL Server, using the path put into a text box "pathInputTextBox" and table name from a ...
- 21
0
votes
2
answers
475
views
How to specify a custom DateOnly format with CsvReader?
I need to read a CSV file using CsvReader, however I have a custom date format (yyyyMMdd) which by default can't be converted to DateOnly. How can I specify this custom date format? Is that may ...
- 17.4k
1
vote
1
answer
701
views
How to specify default int value for empty strings when using CsvDataReader in CsvHelper
I want to use CsvReader and CsvDataReader to load the input CSV into a DataTable, where the colums in the destination data table defines the data types.
But for columns e.g. of int type, the CSV ...
- 25
0
votes
1
answer
798
views
How to detect if a row has extra columns (more than the header)
While reading a CSV file, how can I configure CsvHelper to enforce that each row has no extra columns that are not found in the header? I cannot find any obvious property under CsvConfiguration nor ...
- 3
0
votes
1
answer
1k
views
how do you combine columns into one field with CSVhelper
How do you combine columns into one field with CsvHelper?
I'm using CsvHelperby joshclose. Is possible to join two columns into one when doing the mapping?
I.e csv file has two headers, first and last ...
- 31
-1
votes
1
answer
1k
views
How to read double quotes (") in CsvReader using c#? [duplicate]
I am trying to read a csv file using the following code. Its throwing an exception if there is double quotes (") in the data. I want to handle all the special chars while reading.
using (...
- 223
0
votes
1
answer
1k
views
Error when read text from .csv fie in c# by using CsvHelper
I have a .csv file, with header column in first row. I have issue when read values from this file, although I follow sample code in CsvHelper main page (https://joshclose.github.io/CsvHelper/getting-...
- 27
0
votes
1
answer
200
views
Can CsvReader use different Record Type Maps based upon column count?
I have a bunch of CSV files that I need to read that are similar except for the addition of a column. Essentially, the old CSV format has 7 columns, and the new will have 8. No headers. Once read, the ...
0
votes
1
answer
312
views
Create maps from dynamic collection no longer works: Unable to cast object of type System.String to System.Object)
We are porting legacy code to dotnet standard and are facing an issue which [I believe] wasn't present in CsvHelper 2.5.0 net451.
The issue appears to be that CsvReader can't manage to resolve the ...
- 10.1k
6
votes
5
answers
10k
views
CSVHelper does not parse my Tab delimited CSV file
I am trying to read a tab delimited CSV file and parse it with CSVHelper.
I have the following :
_reader = new StreamReader(_stream);
_csvReader = new CsvReader(_reader);
_csvReader.Configuration....
- 3,799