Actually, the display field shows all the fields -- but places a delimiter between the fields (a pipe "|"). Depending on the field, the delimiter may be unique enough to query it. Another option -- using regular expressions to match the presence of multiple field items -- though that's not as straightforward I would guess.
--TR
> -----Original Message-----
> From: MarcEdit support in technical and instructional matters
> [mailto:[log in to unmask]] On Behalf Of Stacy Pober
> Sent: Tuesday, April 27, 2010 11:15 AM
> To: [log in to unmask]
> Subject: Re: [MARCEDIT-L] Extra fields and missing fields
>
> Thanks, Erin,
>
> I totally see how this will work for detecting records that lack a
> particular field.
>
> However, for records that have multiple 856 fields, I don't think this
> would work. When you use the Marcedit Extract or Delete function, and
> your display field is a recurring field, I think the display shows the
> first instance of that field. I don't think there is anything to tip
> the user off to the fact that a particular field is a recurring one.
> Sometimes the "extra" 856 will be the one shown, but if it is not the
> first instance of 856 in that record, I don' t think I'll see it.
>
> I'm going to use your trick for finding the missing fields immediately.
> Thanks!
>
> Stacy
>
> On Tue, Apr 27, 2010 at 11:50 AM, Erin Stalberg
> <[log in to unmask]> wrote:
> > Kristin E. Martin wrote:
> >> There may be a way to do this in MarcEdit
> >
> > I use the Extract MARC record tool for all kinds of ways in which it
> > probably wasn't intended, but this is one of them!
> >
> > Under the Tools menu on the opening window: Select MARC Records =>
> Extract
> > Selected Records
> >
> > Under Source MARC file, find your file
> > Under Display Field, choose 856$u (or whatever other field you want
> to
> > display on)
> > Click "Import File", you'll get a tab delimited view of record
> numbers &
> > 856$u
> >
> > Like any other Windows app, click on the header to sort by the column
> > (856$u). Records with non-existent 856 tags will show up as "Display
> field
> > not found" (and you can search on that in the search box too if you'd
> like
> > to select all those). Multiple 856's will string together, but you
> can
> > generally do a pretty quick visual scan to identify those (unless you
> have a
> > huge number of records).
> >
> > You can report out selected records by clicking "generate report" and
> then
> > you can find those record numbers & fix them.
> >
> > Or you can extract the selected records into their own file, if
> that's
> > easier for the next step in your workflow.
> >
> > I LOVE this tool, it is incredibly useful for searching/scanning on a
> > particular field in a spreadsheet-like way within MarcEdit.
> >
> >
> > Erin Stalberg
> > Head, Metadata and Cataloging
> > North Carolina State University Libraries
> > [log in to unmask]
> > 919.515.5696
> >
> >
> >
> > > 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]
> >
> >
> _______________________________________________________________________
> _
> >
> > 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]
> >
>
>
>
> --
> Stacy Pober
> Information Alchemist
> Manhattan College Library
> Riverdale, NY 10471
> [log in to unmask]
>
> _______________________________________________________________________
> _
>
> 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 MARCEDIT-L-
> [log in to unmask] To unsubscribe, send a message "SIGNOFF
> MARCEDIT-L" to [log in to unmask]
________________________________________________________________________
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]
|