FacebookTwitterLinkedIn
Login / Register

Login / Register

IUG FORUM

Stay always connected!
  1. Nancy Bennett
  2. Sierra/ Millennium/ Encore
  3. Friday, January 05 2018, 01:46 PM
  4.  Subscribe via email
In Sierra I am trying to do a Create List where the 001 field does NOT start with "ebr" but the 003 includes "EBR". I know I need to do a Regular Expression for the 001 field, but all the variations I've tried have 1) returned 0 results, 2) returns all the results that start with "ebr" or, 3) hangs forever and I have to cancel the request.

The simplest iteration I tried was
bib !001 matches ^[^ebr]

Am I crazy to think this should be something simple?

nbennett@carrollu.edu
Comment
There are no comments made yet.
Add Comment
Accepted Answer
David Jones Accepted Answer
0
Votes
Undo
Your strategy is using the logic "starts with any character other than e, b, or r" and not the logic "starts with any string other than 'ebr'." There are also bugs in how the 00x fields are handled. That regular expression would actually be:

MARC Tag 001 matches "^...[^ebr]"

Create Lists doesn't support look-ahead or look-behind logic, so the easiest way around this can't be done.

Two easy ways to do it:

1) Just use the "all fields don't have" operator. It's rare for alphabetical strings to appear anywhere in an 001 except for the start.
2) Use grouping in your regular expression:

BIBLIOGRAPHIC MARC Tag 001 matches "^...([^e]|e[^b]|eb[^r])" AND BIBLIOGRAPHIC MARC Tag 003 has "ebr"

That still may not provide what you want exactly and you may want to use the complete organization code in the 003 (CaPaEBR).

If you have EBL and Ebook Central records, you should be able to exclude those with "^...([^e]|e[^b]|eb[^clr])" instead.

HTH,
David

djones@scu.edu
Comment
There are no comments made yet.
Add Comment
Nancy Bennett Accepted Answer
0
Votes
Undo
Thanks David! That did the trick and I was able to find the bad records throwing off my counts.

nbennett@carrollu.edu
Comment
There are no comments made yet.
Add Comment
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Guest
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,pdf,ppt,pptx,doc,docx,xls,xlsx,,txt,rtf,jrxml
• Remove Upload Files (Maximum File Size: 2 MB)
You may insert polls into your post. The poll would then appear in the post.
Vote Options
Captcha
To protect the site from bots and unauthorized scripts, we require that you enter the captcha codes below before posting your question.