validate a Excel / xls / csv file quickly?

Question

Hey people

I have about 100 files in .xls with the same header (order number, amount, order name, date of purchase, etc), and need to run them against some checks, e.g.: date is yyyymmdd, order amount is bigger than zero, there are no duplicates for each combination of (customer ID, time order made, product ID) etc.

I don't want to parse the files field-by-field, especially when it is possible that the format will change (and related checks with it).

Maybe someone knows a quick way to do the validation --- like a .dll or application ?

Many thanks !!
V.

Answer 1

Hi,



I use Flat File Checker (FlaFi) for validation of csv files. With it you can easily create a schema with data rules for you files through GUI. When you have the schema file, you can run validation through user interface, command line or use API.



FlaFi has good data rules builder that will allow you to create complex rules without coding.



Hope that will help.

Answer 2

Csv Validator

Answer 3

You should use validation in the first place to trap the following errors :- A blank allow, Minimum/Max character length, Type (String, value or date), Lowest/Highest value allowed, Choice based on a set Value Range.