Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Re: Output to an Excel Document

by joe++ (Friar)
on Mar 13, 2003 at 12:22 UTC ( [id://242667]=note: print w/replies, xml ) Need Help??


in reply to Re: Output to an Excel Document
in thread Output to an Excel Document

Agreed, just be careful if fields starting with a double quote which is not matched later on. This starts an ad-hoc interpretation of the rest of the file as CSV...

I was bitten by this just recently. Of course a simple regex will help in this case (pseudo code): 

for each $field
{ 
  $field =~ s/^"//;
}

[download]

--
Cheers, Joe

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://242667]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others romping around the Monastery: (4)
As of 2024-04-20 16:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found