| 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 |
|
 |
|