Hi<br>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.<br><br>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.<br>
<br>Here is my PFT. Pl. feel free to improve this pft and share it.<br><br> v40/v60/<br>if p(v300) then (v300+|; |) else if a(v300) then 'none' fi fi/<br>if p(v310) then mhl,v310 else if a(v310) then 'none' fi fi/<br>
v200^*, ": "v200^o/ if p(v202) then mhl,v202 else if a(v202) then 'none' fi fi/<br>if p(v205) then v205 else if a(v205) then 'none' fi fi/<br>if p(v210) then v210 else if a(v210) then 'none' fi fi/<br>
if p(v260) then v260 else if a(v260) then 'none' fi fi/<br>if p(v320) then v320 else if a(v320) then 'none' fi fi/<br>if p(v400) then v400^p": ",v400^n else if a(v400) then 'none' fi fi/<br>
if p(v440) then v440 else if a(v440) then 'none' fi fi/<br>if p(v480) then v480 else if a(v480) then 'none' fi fi/<br>if p(v490) then "v."v490^v", ", v490^o", ",v490^p"p." else if a(v490) then 'none' fi fi/<br>
if p(v620) then (v620+|; |) else if a(v490) then 'none' fi fi/<br><br><div class="gmail_quote">Deepali Talagala<br>Head/ Library & Information Services<br>Marga Institute<br>Sri Lanka<br><br>0094 11 2888790/791 (Mobile: 0718260485) <br>
<br><br>On Fri, Oct 14, 2011 at 1:04 PM, De Smet Egbert <span dir="ltr"><<a href="mailto:egbert.desmet@ua.ac.be">egbert.desmet@ua.ac.be</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hello,<br>
<br>
if you want to drop subfields markers and cope with repeatable fields for an Excel export, you have to do the following :<br>
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<br>
mhl, v11 will print Guevara, Fidel<br>
but :<br>
v11^b,|; |v11^a will print : Fidel; Guevara<br>
so you can not only manipulate their sequence (here it is reversed) but also define the separator (here a '; ').<br>
<br>
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.<br>
So if v11 contains 2 occurrences : Descriptor1 and Descriptor2, use the following command to print them separated by a dash (-) :<br>
(v11+| - |)<br>
to produce :<br>
Descriptor1 - Descriptor2<br>
<br>
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.<br>
<br>
Egbert de Smet<br>
Universiteit Antwerpen<br>
________________________________________<br>
From: Sharon Samaniego [<a href="mailto:shaowon@yahoo.com">shaowon@yahoo.com</a>]<br>
Sent: Friday, October 14, 2011 3:42 AM<br>
To: De Smet Egbert; Dr Pawan Kumar Gupta; <a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><br>
<div class="im">Subject: Re: [Isis-users] ISIS and EXCEL<br>
<br>
Hello!<br>
<br>
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.<br>
<br>
Sharon Samaniego<br>
Electronic Resource Services Librarian<br>
De La Salle University - Dasmariñas<br>
Cavite, Philippines<br>
<br>
________________________________<br>
From: De Smet Egbert <<a href="mailto:egbert.desmet@ua.ac.be">egbert.desmet@ua.ac.be</a>><br>
To: Dr Pawan Kumar Gupta <<a href="mailto:pawan.jp@gmail.com">pawan.jp@gmail.com</a>>; "<a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>" <<a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>><br>
Sent: Saturday, October 1, 2011 3:40 PM<br>
Subject: Re: [Isis-users] ISIS and EXCEL<br>
<br>
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.<br>
|"|v1|"|,',',|"|v2|"|,',',|"|v3|"|<br>
to produce your fields embedded in quotes ('delimited') and separated by comma's.<br>
Print your data with such a PFT to a file and open the file in Excel.<br>
<br>
Such data can be imported directly into Excel or other spreadsheet software (and most statistical software as well).<br>
<br>
In ABCD you can directly send your data into the default spreadsheet of your Operating System.<br>
<br>
<br>
________________________________________<br>
</div>From: <a href="mailto:isis-users-bounces@iccisis.org">isis-users-bounces@iccisis.org</a><mailto:<a href="mailto:isis-users-bounces@iccisis.org">isis-users-bounces@iccisis.org</a>> [<a href="mailto:isis-users-bounces@iccisis.org">isis-users-bounces@iccisis.org</a><mailto:<a href="mailto:isis-users-bounces@iccisis.org">isis-users-bounces@iccisis.org</a>>] on behalf of Dr Pawan Kumar Gupta [<a href="mailto:pawan.jp@gmail.com">pawan.jp@gmail.com</a><mailto:<a href="mailto:pawan.jp@gmail.com">pawan.jp@gmail.com</a>>]<br>
<div class="im">Sent: Saturday, October 01, 2011 8:25 AM<br>
</div>To: <a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><mailto:<a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>><br>
<div class="im">Subject: [Isis-users] ISIS and EXCEL<br>
<br>
Dear freinds,<br>
I wish to know if we can print isis output files in the MS EXCEL? Please suggest.<br>
<br>
--<br>
Dr Pawan Kumar Gupta<br>
Adjunct Professor, Department of Lib & Inf Sc, University of Rajasthan,<br>
Jawahar Lal Nehru Marg,<br>
Jaipur - 302 055 INDIA<br>
<a href="tel:%2B91-98283-05458" value="+919828305458">+91-98283-05458</a><br>
<br>
<br>
_______________________________________________<br>
isis-users mailing list<br>
</div><a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><mailto:<a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a>><br>
<div class="im">To manage your own subscription options go to: <a href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a><br>
</div>Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a><mailto:<a href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a>><br>
<div><div></div><div class="h5"><br>
<br>
_______________________________________________<br>
isis-users mailing list<br>
<a href="mailto:isis-users@iccisis.org">isis-users@iccisis.org</a><br>
To manage your own subscription options go to: <a href="http://lists.iccisis.org/listinfo/isis-users" target="_blank">http://lists.iccisis.org/listinfo/isis-users</a><br>
Or contact Henk Rutten: <a href="mailto:hlrutten@xs4all.nl">hlrutten@xs4all.nl</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><br><br>