title: Split in csv file using perl?
body: <p>friends i have two CSV files i need to convert to spread sheet. It contains following data;</p>
  
  <pre><code>"xxx","yyy","97,234"
       .
       .
       .
  </code></pre>
  
  <p>and </p>
  
  <pre><code>abc,def,"23,475"
         .
         .
         .
         .
  </code></pre>
  
  <p>now what is the problem is i need to open this csv file and write each record it into another file.i've tried with split function as <code>split(,@lines)</code> this 'll split all coma separated values so fist file third record also split by two!.so i've tried another way <code>split(",@lines)</code> this method won't support second file!any method to handle this case using <strong><em>perl</em></strong></p>