ForumsQuestionsCSV Notebook Import, Delimiter
CSV Notebook Import, Delimiter
| Author | Message |
|---|---|
|
michi-b |
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 |
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 |
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 |
Here is a good explanation of the CSV file format.
http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm |
|
michi-b |
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.