[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