I need to modify a field in a CSV file. I can use text::csv_xs to parse the file and change the field but when I write the fields back to the output file, I can't get the double quotes and comma (delimiters) to print. In other words, the only change to the input CSV file content should be the field my perl script modifies.

For example, with data such as

"What, a nice day",This is a field,"Here is an,and day"

The above has 3 fields. Let's say that the perl script modifies the 2nd entry to change 'field' to 'fence'. My perl script does this with no problems but it prints the output without the quotes or commas with the exception of commas inside a field.

Here is my output

What, a nice day This is a fence Here is an,and day

but I wanted the output to be the same as the input with only the field change that my script made. SO the desired out is

"What, a nice day",This is a fence,"Here is an,and day"

I would greatly appreciate some help on how to solve this problem

In reply to how to modify a field in a CSV file by beerman

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.