Welcome, Guest. Please login or register.
April 18, 2014, 12:49:25 PM
Home Help Search Calendar Login Register
Show unread posts since last visit.
News: Let Pardus-Anka become #1: Pardus-Anka Bug ReportPardus-Anka World Google+ | The Pardus wiki  | Visit Pardus-Anka official website  | Register as forum member?  Email the moderator!

+  Pardus Worldforum
|-+  Assistance
| |-+  Pardus for beginners
| | |-+  can't view .CSV format [solved]
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Print
Author Topic: can't view .CSV format [solved]  (Read 1478 times)
Lisa
Pardus Guru
****
Posts: 841



View Profile
« on: August 16, 2010, 22:29:20 PM »

Hi all,

My husband sent me a .csv file from his bank, but I can't find anything on Linux that reads these properly.  When I click to view it in my web-based e-mail, it wants to open it with openoffice calculator, but it gibberish.  Or, is there a way to convert this file to PDF in Linux? 
Lisa Marie

Ups, edited to add, that I tried opening it with Kwrite, and it makes sense now.   Grin
Logged
atolboo
Pardus Guru
****
Posts: 2317



View Profile
« Reply #1 on: August 17, 2010, 13:32:06 PM »

In the menu Help of OpenOffice.org Calc (=F1) I find (after doing a 'csv' search and translated from Dutch):
Quote
To Import a CSV File
      1. Choose File - Open
      2. Locate the .........
Maybe this does the trick Wink
« Last Edit: August 17, 2010, 13:37:56 PM by atolboo » Logged
Lisa
Pardus Guru
****
Posts: 841



View Profile
« Reply #2 on: August 17, 2010, 18:44:37 PM »

ah, I always go half the distance.  I never thought of looking in 'Help'. 
I assumed openoffice couldn't read .csv format. 

Code:
To Open a Text CSV File in Calc
1. Choose File - Open.
2. Locate the CSV file that you want to open.
If the file has a *.csv extension, select the file.
If the CSV file has another extension, select the file, and then select "Text CSV" in the File type box
3. Click Open.
The Text Import dialog opens.
4. Specify the options to divide the text in the file into columns.
You can preview the layout of the imported data at the bottom of the Text Import dialog.
I was a bit confused by section 4, as I didn't see 'columns'  but did see 'comas' and chose that.  It looks fine now.  A much better solution!  Thanks, atolboo!
Regards, Lisa Marie
Logged
PhiX
Pardus Guru
****
Posts: 642



View Profile WWW
« Reply #3 on: August 17, 2010, 19:41:40 PM »

csv stands for "comma-separated values". It's a simple text file format in which a column is symbolized by the space in between two commas.
« Last Edit: August 17, 2010, 19:43:39 PM by PhiX » Logged

Team Pardus-fr - French Pardus tools translator
atolboo
Pardus Guru
****
Posts: 2317



View Profile
« Reply #4 on: August 17, 2010, 20:42:24 PM »

csv stands for "comma-separated values". .....
Have a look in the link which is in
....... a 'csv' search ......
Logged
Lisa
Pardus Guru
****
Posts: 841



View Profile
« Reply #5 on: August 18, 2010, 17:09:05 PM »

Thanks for the additional information.  It looks like .csv has been around for a long time. 

I knew that commas had something to do with the format, after looking at an example entry my husband sent to me: "09/01/2010","222.22",,"Uncategorized","E-PMT","SOMEONE"
Lisa Marie
Logged
James T
Pardus Master
***
Posts: 155



View Profile
« Reply #6 on: August 18, 2010, 23:14:06 PM »

It's also worth noting that the CSV import in OpenOffice can handle a wide range of separators beyond just commas, and in recent versions does a pretty good job of guessing the format of the file.  Though you may need to tweak things like the behaviour with multiple separators.
Logged
Pages: [1] Go Up Print 
« previous next »
Jump to:  


Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!