Hi Mary, I believe I can help with your XPath questions. If you wanted to get just the "current/latest" dates, and only publication dates (as opposed to distribution, etc) you could do something like this:
//*[(@tag="260" and @ind1="3") or (@tag="264" and @ind1="3" and @ind2="1")]/*[@code="c"] I imagine the indicator 1 values may be too strict, though. To get just the first found in the record (and without the perhaps-too-strict indicator 1 tests): //*[@tag="260" or (@tag="264" and @ind2="1")]/*[@code="c"][1] And to get the last, presumably the 264 if it exists: //*[@tag="260" or (@tag="264" and @ind2="1")]/*[@code="c"][last()] Ordering is based on document element order, FWIW. And, finally, the "Remove \D" refers to removing non-numeric characters from the extracted string. HTH, -- Mike Rylander | Executive Director | Equinox Open Library Initiative | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@equinoxinitiative.org | web: http://equinoxinitiative.org On Fri, Jun 14, 2019 at 2:48 PM Mary Llewellyn <mllew...@biblio.org> wrote: > Hi Janet, > > You inspired me to tweak my Vandelay queue display. I figured out how to > combine the two publisher tags, and now I don't have any empty boxes in the > publisher column. > > *//*[@tag="260" or @tag="264"]/*[@code="b"]* > > I tried the same thing with the pub dates, but ended up with two dates > strung together when there are 2 264 tags for the differing types of dates. > I either need to now how to insert a space between them, or how to skip one > iteration based on indicator values. > > /*/*[@tag="260"or @tag="264"]/*[@code="c"] Remove \D* (That last > part was already in place, I don't really know what it means.) > > Anyway, thanks for the inspiration! > > Mary > > > On Tue, Jun 11, 2019 at 2:59 PM Janet Schrader <jschra...@cwmars.org> > wrote: > >> Hi, >> I do not do reports, but I can say that in Vandelay I have two columns >> for publisher: Publisher and Publisher RDA and likewise two columns for Pub >> date and Pub date RDA. I have this attribute definition for the RDA >> publisher. Is it possible to use this for reports? >> *264 b //*[@tag="264"]/*[@code="b"]* >> >> >> Janet >> >> >> Janet Schrader >> >> Bibliographic Services Supervisor | CW MARS >> >> 67 Millbrook Street, Suite 201, Worcester, MA 01606 >> >> P: 508-755-3323 x 325 | F: 508-757-7801 >> >> ------------------------------ >> >> jschra...@cwmars.org || http;//cwmars.org <http://www.cwmars.org/> >> >> >> >> On Tue, Jun 11, 2019 at 12:51 PM Jane Sandberg <sand...@linnbenton.edu> >> wrote: >> >>> John Yorio at Equinox helped me track this down in our system. John >>> found out that the issue was that Evergreen uses the Library of Congress' >>> MARC->MODS 3.3 mapping, which only includes 260$b publishers. See >>> https://www.loc.gov/standards/mods/v3/mods-mapping-3-3.html#publication >>> >>> I think a bug report would be a good idea. >>> >>> On Tue, Jun 11, 2019 at 8:45 AM Patrick, Irene <irene.patr...@ncdcr.gov> >>> wrote: >>> >>>> Someone here asked me for a report that includes the Publisher >>>> information. In the report I created, I used the Simple Record Extracts to >>>> pull the “Publisher (normalized)” field into the report. Unfortunately, in >>>> the output, the Publisher column was mostly empty. On investigation, it >>>> appears that records with the publisher in the 264 are not included in the >>>> output. Only records where the publisher is in the 260 have the publisher >>>> information show up in the output. >>>> >>>> >>>> >>>> We are on Evergreen 3.1.6. I’ve searched Launchpad, but I don’t find >>>> anything about this issue. Has it been corrected in a later release? Or >>>> do we need to create a bug report? >>>> >>>> >>>> >>>> Or should I use a different method to get the publisher information >>>> into the report? >>>> >>>> >>>> >>>> *Irene Patrick * >>>> >>>> Library & Information Management Systems Librarian, NC Government & >>>> Heritage Library >>>> >>>> NC Dept. of Natural and Cultural Resources >>>> >>>> 919.814.6788 | irene.patr...@ncdcr.gov >>>> >>>> >>>> >>>> 109 E. Jones Street | 4640 Mail Service Center >>>> >>>> Raleigh, North Carolina 27699-4600 >>>> >>>> Facebook <http://www.facebook.com/ncghl> Instagram >>>> <https://www.instagram.com/foreverythingnc/> Twitter >>>> <https://twitter.com/ForEverythingNC> YouTube >>>> <https://www.youtube.com/statelibrarync> Website >>>> <https://statelibrary.ncdcr.gov/> >>>> >>>> >>>> >>>> *Email correspondence to and from this address is subject to the North >>>> Carolina Public Records Law and may be disclosed to third parties.* >>>> >>>> >>>> >>> >>> >>> -- >>> Jane Sandberg >>> Electronic Resources Librarian >>> Linn-Benton Community College >>> sand...@linnbenton.edu / 541-917-4655 >>> Pronouns: she/her/hers >>> >> > > -- > Mary Llewellyn > Database Manager > Bibliomation, Inc. > 24 Wooster Ave. > Waterbury, CT 06708 > mllew...@biblio.org >