I asked this last week but I never gave a proper real live example of my csv.....Sorry ..My Fault
Here goes...I need a regular expression to validate a csv for the below file example.
0067,Medium,7NOK6XX45,,,CHEMDRY SECTION,5 The River,Riverside Lock,Kilcullen,Co Kildare,028BS007REIL3000,Donn,McGull,045481400
0067,Medium,7NOK62245,,,WALLACE SECTION,5 The Ware,Moore Side,Drumgan,Co Clare,028BS007REIL9000,Donn,McGull,045481422
Validation Needed is
Total Number of fields must be 14
Field Lengths can not exceed Spec (Below)
Field3 and Field 11 must be CAPS
Field1 and field3 and field6 and field7 and field11 can not be empty.
Field length Chart:
Can someone please help...