| View previous topic :: View next topic |
| Author |
Message |
jdaum
General User
Joined: 17 Sep 2004
Posts: 13
|
 Posted: Fri Sep 17, 2004 9:34 pm Post subject: csv import (again...) |
 |
|
Hi,
I have problems importing my online banking data into Calc.
The file has three columns, the second being in double quotes and the lines delimted by LF only (0x0A).
Accoring to the other posts, I choose File -> Open, select Text CSV as a file type. On the next dialogue I choose LF as a line delimiter.
I opens in Writer. I have also removed the double quotes. Doesn't help.
Any further ideas?
Jochen |
|
| Back to top |
|
 |
esperantisto
Super User
Joined: 26 Dec 2003
Posts: 772
Location: Belarus
|
| Posted: Sun Sep 19, 2004 2:24 am Post subject: |
|
|
| Unfortunately, I can't reproduce your problem. I've created a text file with 3 rows and 3 columns, one with double quotes, with LF only as line divider, and it was prefectly imported into Calc using File -> Open with Text (CSV) chosen as file type. |
|
| Back to top |
|
|
jdaum
General User
Joined: 17 Sep 2004
Posts: 13
|
| Posted: Sun Sep 19, 2004 2:03 pm Post subject: Solved! |
|
|
Hi,
You not being able to reproduce it made me think of trying to write a new file as well. I then looked for things which are different.
The file which I couldn't import had a single space (0x20) in the last line.
Removing this space fixed it |
|
| Back to top |
|
|
|
