Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

how to print commas in csv

by loki (Novice)
on Jan 04, 2010 at 09:21 UTC ( #815546=perlquestion: print w/replies, xml ) Need Help??

loki has asked for the wisdom of the Perl Monks concerning the following question:

hi,i have an Excel sheet and am able to convert it into .csv format using Perl Parse::Excel. My only problem is that some of my data in the Excel sheet cells contain commas and that has to be retained in the CSV format also, but while converting it takes as a seperator. How can I retreive the data in the cell with commas as it is and print it in the CSV?

For example, in the Excel sheet A1 cell contains the data {0xAAAA,0xFFFF,0xAAAA,0xAAAA} I want the same data with commas in the A1 cell in CSV file also. I am using Spreadsheet::ParseExcel.

Replies are listed 'Best First'.
Re: how to print commas in csv
by Corion (Patriarch) on Jan 04, 2010 at 09:33 UTC

    How to retain commas in CSV is a question of how your receiving program parses the CSV. I'd use Text::CSV to write the CSV, then it will write the files mostly like Excel would, using double quotes to denote strings.

      Yup, I agree here.

      Another possibility is if the receiving program can define its separator to use a different character to comma not found in the data. (I like TAB).

        I love TAB so much that i have this in my .vimrc:
        """""""" "" Rotate tabstop value between 2, 4, 8, 16, 32 and 64 "" Mapped to <F2> "" function FDO_TabToggle () let TabStopVal = &tabstop let TabStopVal = TabStopVal * 2 if TabStopVal > 64 let TabStopVal = 2 endif let &tabstop = TabStopVal echo"TabStop is now: " TabStopVal endfunction
        A reply falls below the community's threshold of quality. You may see it by logging in.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://815546]
Approved by broomduster
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (3)
As of 2022-10-02 09:02 GMT
Find Nodes?
    Voting Booth?
    My preferred way to holiday/vacation is:

    Results (8 votes). Check out past polls.