[Isis-users] ISIS and EXCEL

[De Smet Egbert]

Hello,

if you want to drop subfields markers and cope with repeatable fields for an Excel export, you have to do the following :
1. for the subfields : print them without markers, either by using mode 'H' (e.g. mhl) or by separately referencing the subfields so that you can define the separator yourself, e.g. if v11 contains : ^aGuevara^bFidel
mhl, v11 will print Guevara, Fidel
but :
v11^b,|; |v11^a will print : Fidel; Guevara
so you can not only manipulate their sequence (here it is reversed) but also define the separator (here  a '; ').

2. for the repeatable fields : you will need to print all occurrences with a separator into one single field as Excel doesn't know repeatable fields.
So if v11 contains 2 occurrences : Descriptor1 and Descriptor2, use the following command to print them separated by a dash (-) :
(v11+| - |)
to produce :
Descriptor1 - Descriptor2

It is then the responsibility of the software dealing with these comma-delimted data to see (or not) the delimiters and to use them to deal with each occurrence separately.

Egbert de Smet
Universiteit Antwerpen
________________________________________
From: Sharon Samaniego [shaowon at yahoo.com]
Sent: Friday, October 14, 2011 3:42 AM
To: De Smet Egbert; Dr Pawan Kumar Gupta; isis-users at iccisis.org
Subject: Re: [Isis-users] ISIS and EXCEL

Hello!

I've tried this option but I think it is not working. In my fdt I have repeatable and subfielded fields. Is there a different command for the subfielded and repeatable fields? Attached here is the xls which I have printed out from WinISIS.

Sharon Samaniego
Electronic Resource Services Librarian
De La Salle University - Dasmariñas
Cavite, Philippines

________________________________
From: De Smet Egbert <egbert.desmet at ua.ac.be>
To: Dr Pawan Kumar Gupta <pawan.jp at gmail.com>; "isis-users at iccisis.org" <isis-users at iccisis.org>
Sent: Saturday, October 1, 2011 3:40 PM
Subject: 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<mailto:isis-users-bounces at iccisis.org> [isis-users-bounces at iccisis.org<mailto:isis-users-bounces at iccisis.org>] on behalf of Dr Pawan Kumar Gupta [pawan.jp at gmail.com<mailto:pawan.jp at gmail.com>]
Sent: Saturday, October 01, 2011 8:25 AM
To: isis-users at iccisis.org<mailto: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<mailto: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<mailto:hlrutten at xs4all.nl>