[Isis-users] ISIS and EXCEL

Piet De Keyser piet.dekeyser at khleuven.be
Sat Oct 1 21:21:29 CEST 2011


Hi all,

For those who are a little bit acquainted with the Cisis tools (MX): you can easily export a database in comma delimited format using this command:

mx dbname fix=test.csv

The csv file will  be delimited with pipes.

Piet de Keyser
Belgium

________________________________________
Van: isis-users-bounces at iccisis.org [isis-users-bounces at iccisis.org] namens De Smet Egbert [egbert.desmet at ua.ac.be]
Verzonden: zaterdag 1 oktober 2011 9:40
Aan: Dr Pawan Kumar Gupta; isis-users at iccisis.org
Onderwerp: Re: [Isis-users] ISIS and EXCEL

You can print, as has been discussed many times in this list, your ISIS-data as 'comma-delimited' (or CSV) data with a simple PFT like e.g.
|"|v1|"|,',',|"|v2|"|,',',|"|v3|"|
to produce your fields embedded in quotes ('delimited') and separated by comma's.
Print your data with such a PFT to a file and open the file in Excel.

Such data can be imported directly into Excel or other spreadsheet software (and most statistical software as well).

In ABCD you can directly send your data into the default spreadsheet of your Operating System.


________________________________________
From: isis-users-bounces at iccisis.org [isis-users-bounces at iccisis.org] on behalf of Dr Pawan Kumar Gupta [pawan.jp at gmail.com]
Sent: Saturday, October 01, 2011 8:25 AM
To: isis-users at iccisis.org
Subject: [Isis-users] ISIS and EXCEL

Dear freinds,
I wish to know if we can print isis output files in the MS EXCEL? Please suggest.

--
Dr Pawan Kumar Gupta
Adjunct Professor, Department of Lib & Inf Sc,  University of Rajasthan,
Jawahar Lal Nehru Marg,
Jaipur - 302 055  INDIA
+91-98283-05458


_______________________________________________
isis-users mailing list
isis-users at iccisis.org
To manage your own subscription options go to: http://lists.iccisis.org/listinfo/isis-users
Or contact Henk Rutten: hlrutten at xs4all.nl


More information about the isis-users mailing list