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>
