Legend

Forum

Unread topics or posts

Topic

Unread posts

Locked

Announcement

Forums > Questions

CSV Notebook Import, Delimiter



AuthorMessage
michi-b

Posted: Jan 24, 2009
Score: 0



Hey Folks!

I was trying to import a CSV file with ";" as delimiter into my notebooks (edited Palm Desktop for MAC export). But the import wizard seemes to use "," as delimiter, which is kind of senseless, because a lot of note entries contain "," as regular phrase content.

Is there a way to import ";"-CSV files?
Jake

Toodledo Admin
Posted: Jan 25, 2009
Score: 0



CSV stands for Comma Separated Values, so using a comma is the correct way to delimit the values. If you have a field that has commas in it, then you surround it with "quotes" and it will be fine.
michi-b

Posted: Jan 26, 2009
Score: 0



Well, I followed the manual of the Appigo Notebook Tips& Tricks Website (http://www.appigo.com/notebook/tips/import-palm-mac) to import my Palm Notes. Usually, Excel creates CSV-files with a semi colon as delimiter, which is quite usual too.

Palm Desktop doesn't export line breaks in notes as it, so they have to be replaced/reconstructed manually (see manual above). For that, I've already quoted the fields, but the CSV import Wizard doesn't seem to respect the quotes.
Jake

Toodledo Admin
Posted: Jan 26, 2009
Score: 0



Here is a good explanation of the CSV file format.

http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm
michi-b

Posted: Jan 28, 2009
Score: 0



Thanks a lot for your hint!

Had to quote consistently every cell and also the already existing quotes ("-> "") in the messages. Now it works fine and I was able to import all my Palm messages.
You cannot reply yet


To participate in these forums, you must be signed in.



Toodledo Forums > Questions

Contact Us | Blog | API | Jobs | Press | Documentation | Forums Privacy | Terms | Copyright © 2004-2014