MARCEDIT-L Archives

April 2010

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"Kristin E. Martin" <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Tue, 27 Apr 2010 08:24:21 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (47 lines)
There may be a way to do this in MarcEdit, but what I'd do is export the 
fields in question along with the record identifier to a tab-delimited 
file and then importing into a spreadsheet.  For the URLs, you can use 
break multiple values into multiple columns (in Excel, use the "Text to 
Column" function) and then see which have multiple URLs.  For fields 
where data is missing, a simple sort or filter for blanks while bring up 
the missing values and you could then go into MarcEdit and manually edit 
those records.

Kristin

Kristin E. Martin
Metadata Librarian
Catalog Department (MC 234)
2-390 Richard J. Daley Library
University of Illinois at Chicago
801 S. Morgan
Chicago, IL  60607
312-413-5052
312-413-0424 (Fax)
[log in to unmask]



Stacy Pober wrote:
>  If I'm looking at a field report in Marcedit, it will tell me whether
> there are more more 856 fields than the one per record that  we
> expect. Is there a utility/function/search that I can do to find which
> are the records that have more than one instance of a particular
> field?  In this case, the field can legitimately repeat so using the
> validator won't catch this.
>
> (The specific problem is that some of the vendor supplied records for
> ebooks have multiple 856 fields and in some cases, the "extra" URLs
> are for services that our library has no access to.
>
> Also, if I see in the field report that there are too few of
> particular field that I want in every record, is there a search I can
> do to find which records have no instances of a particular MARC field?
>
> Advance thanks,
>   

________________________________________________________________________

This message comes to you via MARCEDIT-L, a Listserv(R) list for technical and instructional support in MarcEdit.  If you wish to communicate directly with the list owners, write to [log in to unmask] To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask]

ATOM RSS1 RSS2