[Isis-users] ISIS and EXCEL

[Deepali Talagala]

Hi
It was interesting yo read your contributions.  I am using a different
method which may be a long process, but I found it easier. Would like to
share it.

I created a pft given below. I used "none" for the fields in which there may
not be data in all records. Then I printed my database to a word file with
this PFT using the print to file method in WinIsis.  When u have a word file
it is easy convert text to a table.  If you have fifteen fields you have to
create a table with 15 columns.  Then u can copy this table to a excel work
sheet.

Here is my PFT.  Pl. feel free to improve this pft and share it.

  v40/v60/
if p(v300) then (v300+|; |) else if a(v300) then 'none' fi fi/
if p(v310) then mhl,v310 else if a(v310) then 'none' fi fi/
v200^*, ": "v200^o/ if p(v202) then mhl,v202 else if a(v202) then 'none' fi
fi/
if p(v205) then v205 else if a(v205) then 'none' fi fi/
if p(v210) then v210 else if a(v210) then 'none' fi fi/
if p(v260) then v260 else if a(v260) then 'none' fi fi/
if p(v320) then v320 else if a(v320) then 'none' fi fi/
if p(v400) then v400^p": ",v400^n  else if a(v400) then 'none' fi fi/
if p(v440) then v440  else if a(v440) then 'none' fi fi/
if p(v480) then v480  else if a(v480) then 'none' fi fi/
if p(v490) then  "v."v490^v", ", v490^o", ",v490^p"p."  else if a(v490) then
'none' fi fi/
if p(v620) then (v620+|; |) else if a(v490) then 'none' fi fi/

Deepali Talagala
Head/ Library & Information Services
Marga Institute
Sri Lanka

0094 11 2888790/791 (Mobile: 0718260485)


On Fri, Oct 14, 2011 at 1:04 PM, De Smet Egbert <egbert.desmet at ua.ac.be>wrote:

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



--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.iccisis.org/pipermail/isis-users/attachments/20111015/55f8ef84/attachment.html>