RE: Export data from create lists on 863 field in checkin

["Lu, Wen-ying" <luw at mail dot lib dot msu dot edu>]

Thank you very much, Richard!!!  I wouldn't have been able to come up with that formula.

I'll send in an enhancement request to merge caption and enumeration data for output to a separate list. On a second thought, I may also request the numerals in chronology be converted to natural language for output. If anyone likes the idea, please send in an enhancement request for your institution so that III would know MSU is not the only one interested in the enhancement.  Thank you.

Lu
========================
Wen-ying Lu  (Although "Lu" is my last name, I am perfectly comfortable if you just call me Lu.)
Catalog Librarian and Linguistics Bibliographer
100 Library
Michigan State University
East Lansing, MI 48824-1048
Tel. 517-432-6123 ext. 191
FAX: 517-353-8969
e-mail: luw at mail dot lib dot msu dot edu

-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org]On Behalf Of
innopac-request at innopacusers dot org
Sent: Thursday, April 14, 2005 4:01 PM
To: innopac at innopacusers dot org
Subject: INNOPAC Digest, Vol 16, Issue 27

Today's Topics:
.......
  14. RE: Export data from create lists on 863 field in checkin
      (Jackson, Richard)
....
----------------------------------------------------------------------
Message: 14
Date: Thu, 14 Apr 2005 12:06:35 -0700
From: "Jackson, Richard" <rjackson at huntington dot org>
Subject: RE: Export data from create lists on 863 field in checkin
To: "IUG INNOPAC List" <innopac at innopacusers dot org>
Message-ID:
	<83759BCFCBBFE149B14A6448515F2EAF01DBADCE at mercury dot HAL dot HUNTINGTON dot ORG>
Content-Type: text/plain;charset="us-ascii"

Lu,

Here's an Excel formula that will work with either single months or
ranges of months, that is, it will change "4" to "Apr" and "4-12" to
"Apr-Dec".  The data should be in Text format.  This example converts
data in cell D2.

=IF(ISNUMBER(FIND("-",D2)),TEXT((VALUE(LEFT(SUBSTITUTE(D2,"-"," "),2))
*30)-15,"mmm") & "-" & TEXT((VALUE(RIGHT(SUBSTITUTE(D2,"-","
"),2))*30)-15,
"mmm"),TEXT((VALUE(D2)*30)-15,"mmm"))

(Be sure to remove carriage returns from the formula.)

As far as merging caption and enumeration data, perhaps this should be
pursued as an enhancement.  The functionality is there -- the holdings
data is displayed correctly in the OPAC and in the OPAC view of the
checkin record.  It's a matter of being able to output it in that format
from a list of records.

Richard

Richard V. Jackson
Head of Copy Cataloging / Database Manager
Huntington Library, Art Collections, and Botanical Gardens
1151 Oxford Road, San Marino, CA 91108
rjackson at huntington dot org 

***************************************