title: Validation using Regular Expression in C#.net applicaiton
body: <p>We want to validate input .DAT file records for provided deliminators.</p>
  
  <p>In our .net application we can parse input file as per provided deliminator where all deliminator are proper ,
  ex : "Test","data","CaseInforation"</p>
  
  <p>above record/row from file will parse successfully,now we have problem with row/record formatted as below:</p>
  
  <p>"Test",data,"CaseInforation"
  (u can see there is no text qualifier surrounded with 'data' value &amp; because of this it creates problem while parsing data from file).</p>
  
  <p>So we decided to use regular expression to find problematic value which are not surrounded with TextQualifier.</p>
  
  <p>To Resolve this problem, we have created below RegEx to find problematic value,
  \x2C([^\x22].*?[^\x22])\x2C</p>
  
  <p>using above regular expression, it works in records in between first &amp; last fields.</p>
  
  <p>"Test",data,"CaseInforation" -> Regular expression parse this records successfully &amp; providing data as output field having problem.</p>
  
  <p>"Test","data",CaseInforation -> for this record regular expression does not match last value.</p>
  
  <p>can any one help us to correct Regular Expression which would match first or last value.</p>
  
  <p>Thanks.</p>