1 Key question: does your CSV data have an initial row that names colums in a way you can easily infer the column data type ?
2 If you are using zero based indexing: column: 2 row :1 ... is 22.
3 Are there any other numeric types you need to handle other than Int32 ?
There are many CP articles with code for CSV processing that might save you a lot of time; here's a recent one:[
^], For more: [
^].
This discussion on SO describes several approaches to CSV validation; most of them involve conversion to a DataSet, or Class structureL [
^].
If you need to test a string for numeric conversion: Double.TryParse will return 'true for all types of numbers: decimal, float, etc.