ForumsQuestionsCSV Notebook Import, Delimiter


CSV Notebook Import, Delimiter
Author Message
michi-b

Posted: Jan 24, 2009
Score: 0 Reference
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 Founder
Posted: Jan 25, 2009
Score: 0 Reference
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 Reference
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 Founder
Posted: Jan 26, 2009
Score: 0 Reference
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 Reference
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

U Back to topic home

R Post a reply

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