importing CSV file from BENTO to Entourage

I

ImRescued

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
Email Client: imap

When trying to import my CSV file from Bento, the fields are filled in QUOTATION marks in nearly every field. So my fields reads like this...
"DAN" "WILLIAMS" "416 Beverly Dr"
Yuk.
Help?
Dan Williams
 
D

Diane Ross

[email protected] said:
When trying to import my CSV file from Bento, the fields are filled in
QUOTATION marks in nearly every field. So my fields reads like this...
"DAN" "WILLIAMS" "416 Beverly Dr"
Yuk.
Help?
Click to expand...

Open the file in Excel and edit.
 
A

Allen A Watson

Diane said:
Open the file in Excel and edit.
Click to expand...
If you just strip out all quote marks, make sure there are no commas
within any of your fields! It might be easier (than editing in Excel) to
do a global find/replace of the quote marks in TextEdit or another plain
text editor such as Text Wrangler or Tex Edit Plus.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

consolidate calendars 0
Address Book wiped clean 12
Importing data, CSV file to Entourage 2
Importing CSV file into Calendar 5
importing contact 2
Importing contacts from Hotmail 2
importing 1
Importing Contacts from Windows Outlook 2007 to Entourage 08 4

Top