barry-jones / csv-validator Goto Github PK

If a header is expected:

• Validate the number of columns expected (eg: if we specify 10 columns in the definition check that we have 10 headers)
• Validate the header name - if the 'name' property is defined in the schema

When a validation error is provided, the row number is shown but for every error there is a zero displayed for the character position the error occurs at

a) Is there any way to reject if the file has additional columns which are not defined?
or
b) Can I specify maxColumns, along with columnSeperator, which is checked for each row?

Looks like the Regex isn't a bit too capture happy :(

Example with the following input:
somthing,before,\"just, a string\",seperated,after

It actually returns:

Header rows are not validated and when a header row is checked against the row requirements it can produce invalid failures

When a file uses a comma to separate fields, commas in quoted fields are not escaped so they get processed as a new column.

Might be worth looking at CsvHelper as they seem to handle this

It would help the user understand what format is required if the pattern was provided in the error message

After the validation is complete currently the application only provides information about the overall failure or success of the file. When a failure occurs it should display a summary of the errors.

Update validator configuration to make constructing validator configurations easier.

Examples:

ValidatorConfiguration config = new ValidatorConfiguration();
config.Set(1, isNumeric: true);
config.Set(2, maxLength: 20, isRequired: true);
Validator validator = Validator.FromConfiguration(config);

Hi, this looks awesome.

Any chance of deploying as a NuGet package to use as a library within another application.

Large files, especially those which will pass validation do not give any indication to the user that the application is progressing.

It would be helpful to the user to understand which column is invalid.

Hello there. Getting the following error when trying to install this package to a new console project.

https://learn.microsoft.com/en-us/nuget/reference/errors-and-warnings/NU1108

Apparently, it is reporting some sort of circular dependency. Let me know if you need any more information.