IUG FORUM

Stay always connected!
  1. Leanne Olson
  2. Sierra/ Millennium/ Encore
  3. Monday, 15 January 2018
  4.  Subscribe via email
Has anyone had luck with exporting fields from a review file, based on indicators? I have a list of records and I'd like to export, for example, just LCSH, or just MeSH. So I'd like to export just the 650 second indicator zero or just 650 second indicator 2.

Trying things like 650 0 or 650?0 doesn't work; I keep getting all of the 650s, not limited to the LCSH. If I ask for one column with 650 0 and one with 650 2, both exports are identical.

According to the Sierra Manual, however, the functionality is there:

Note that you can export specific MARC fields and subfields by entering the "!" character in the Field box. Enter your MARC field criteria (including indicators and subfields if desired) in the same format used for MARC field searching when creating a review file.


And under field searching, it specifies:

If you choose ! MARC Tag, the system provides a prompt indicating what to enter:
MARC TAG tttii|ssss
ttt 3 numbers for the MARC tag
ii up to 2 numbers or spaces for the indicators (optional)
|ssss up to 4 subfields indicated by the '|' (optional)


However, I can't find an example or figure out how to actually do it. Any thoughts or tips?

lolson3@uwo.ca
Comment
There are no comments made yet.
Accepted Answer Pending Moderation
0
Votes
Undo
You can search on d SUBJECT matches ^6[0135][01].2 to find them.



Then export 650 2.



It doesn't look like you can use a wildcard for the indicator in
export.  I guess you would have to do the various combinations
separately.  Or perhaps load into Excel as a fixed width import,
then you can get the indicators in their own field and filter by
them to find the 2s.



--
Lloyd Chittenden
Union Catalog Coordinator
Marmot Library Network
[email]lloyd@marmot.org[/email]
(970)242-3331 x 113
On 1/15/2018 10:45 AM, Innovative Users
Group wrote:















New Question Posted
Guest
created a new discussion How to export by
MARC field indicators in Create Lists? (e.g.
650_0)
in Sierra/ Millennium/ Encore
















Hello,

This
is a notification to let you
know that Guest has created new
discussion on the site. You may
find the snippet of the new
discussion below:








Has anyone had
luck with exporting fields from a
review file, based on indicators?
I have a list of records and I'd
like to export, for example, just
LCSH, or just MeSH. So I'd like to
export just the 650 second
indicator zero or just 650 second
indicator 2.



Trying things like 650 0 or 650?0
doesn't work; I keep getting all
of the 650s, not limited to the
LCSH. If I ask for one column with
650 0 and one with 650 2, both
exports are identical.



According to the Sierra Manual,
however, the functionality is
there:



Note that you can
export specific MARC fields and
subfields by entering the "!"
character in the Field box.
Enter your MARC field criteria
(including indicators and
subfields if desired) in the
same format used for MARC field
searching when creating a review
file.




And under field searching, it
specifies:



If you choose ! MARC
Tag, the system provides a
prompt indicating what to enter:

MARC TAG tttii|ssss

ttt 3 numbers for the MARC tag

ii up to 2 numbers or spaces for
the indicators (optional)

|ssss up to 4 subfields
indicated by the '|' (optional)




However, I can't find an example
or figure out how to actually do
it. Any thoughts or tips?



[email]lolson3@uwo.ca[/email]







http://innovativeusers.org/index.php/iug-forum/sierra-millennium-encore/11526-how-to-export-by-marc-field-indicators-in-create-lists-e-g-650_0.html"">Read this discussion











This
email was sent to you, because you have
subscribed to the discussion.

To unsubscribe, please http://innovativeusers.org/index.php/iug-forum.html?controller=subscription&task=unsubscribe&data=dHlwZT1jYXRlZ29yeQ0Kc2lkPTI2Ng0KdWlkPTMzMzMNCnRva2VuPTlhZmYxZWNkNGU3MDZhYTc5NmRjMGQxNDFmNjU0Yjlm";">click here.
http://innovativeusers.org/index.php/iug-forum/profile.html#Subscriptions"">Manage
subscriptions.


















lloyd@marmot.org
Comment
There are no comments made yet.
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 1
Accepted Answer Pending Moderation
0
Votes
Undo
Hi Leanne,

We've used this feature at our library when pulling title information in create lists, or to be precise we use this feature in the export function of an existing review file. But I just did a quick test and this works equally well as a search criterion. See the attached screen shots for detailed examples.

Andy

ahelck@telluridelibrary.org
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Sierra/ Millennium/ Encore
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!