title: Validate a csv file
body: <p>This is my sample file</p>
  <pre><code>#%cty_id1,#%ccy_id2,#%cty_src,#%cty_cd3,#%cty_nm4,#%cty_reg5,#%cty_natnl6,#%cty_bus7,#%cty_data8
  690,ALL2,,AL,ALBALODMNIA,,,,
  90,ALL2,,,AQ,AKNTARLDKCTICA,,,
  161,IDR2,,AZ,AZLKFMERBALFKIJAN,,,,
  252,LTL2,,BJ,BENLFMIN,,,,
  206,CVE2,,BL,SAILFKNT BAFSDRTHLEMY,,,,
  360,,,BW2,BOPSLFTSWLSOANA,,,,
  </code></pre>
  <p>The problem is for <code>#%cty_cd3</code> is a <code>standard column(NOT NULL)</code> with length 2 letters only, but in sql server the record shifts to the other column,(due to a extra comma in btw)how do i validate a csv file,to make sure that
  when there's a 2 character word need to be only in 4 column?</p>
  <p>there are around 10000 records ?</p>
  <h2>Set of rules Defined !</h2>
  <pre><code>Should have a standard set of delimiters for eachrow
   if not
     Check for NOT NULL values having Null values
       If found Null
         remove delimiter at the pointer
  </code></pre>
  <p>The 3 <code>,,,</code> are not replaced with 2 <code>,,</code></p>
  <p><s>#UPDATED : Can i know if this can be done using a script ?</s></p>
  <h1>Updated i need only a function That operates on records like</h1>
  <p><code>   90,ALL2,,,AQ,AKNTARLDKCTICA,,,</code> correct them using a Regex or any other method and put back into the source file !</p>