You have an extra double-quote in there after the email address. So far this doesn't seem to be a Perl problem.
-----Original Message----- From: Mihir Kamdar [mailto:[EMAIL PROTECTED] Sent: Sunday, June 25, 2006 7:02 AM To: Mr. Shawn H. Corey Cc: beginners Subject: Re: CSV file that can be loaded to Microsoft Outlook hii, thanx a lot for your immediate reply... now i m able to import but after that it is not taking up correct values. Following is the line that i m trying to import. Now if i keep this as a single line in the CSV file (no word wrap), then Outlook is not importing it. Only if I break the line, then it is taking it...but in that case while maping the fields, when I do next in souce file, then it wipes off all the previous mappings. So ultimately after importing to contacts, I m getting jumbled up values(like Mobile No against first name,etc).. I have no clue as to where i m wrong. , "Suhail", , "Khan", , "Xyz Technologies Ltd", "Engineering", "VP -Engineering", "nth Block, Koramangala", "Bangalore 560 095 India", , , , , , , , , , , , , , , , , , , , , , , , , , "+91-80-25000000, ext 3300", , , , , "+91-9900000000", , , , , , , , , , , , , , , , , " [EMAIL PROTECTED]", , "suhailk", , , , , , , , , , , , , , , , , , , , "004", , , , , , , , , , , , , thanx, mihir On 6/24/06, Mr. Shawn H. Corey <[EMAIL PROTECTED]> wrote: > > On Sat, 2006-24-06 at 10:50 -0400, Ryan Frantz wrote: > > 'CSV' means _Comma_ Separated Values. Semicolons won't work. > > CSV are also doubly escaped. Commas in CSV are escaped by placing them > inside double-quotes. Double-quotes, inside double-quotes, are escaped > by placing two in a row; but if they're outside double-quotes, there's > just one of them. The following is a valid CSV line: > > ,",","""","""""",""",""" > > Confused? I recommend you find a module in CPAN to format your output > correctly. > > http://search.cpan.org/ > > > -- > __END__ > > Just my 0.00000002 million dollars worth, > --- Shawn > > "For the things we have to learn before we can do them, we learn by doing > them." > Aristotle > > * Perl tutorials at http://perlmonks.org/?node=Tutorials > * A searchable perldoc is at http://perldoc.perl.org/ > > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > <http://learn.perl.org/> <http://learn.perl.org/first-response> > > > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
