This is what the delete field utility is for. Set the field to 856, the options to use regular expressions and use this expression -- I have tested it but it should work as it.
Otherwise, there really isn't a good way to do what you are asking -- partly because the mnemonic file format structure is the way that it is. It treats the blank lines as new records.
--tr
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Shirley Lee
Sent: Wednesday, September 28, 2016 7:54 PM
To: [log in to unmask]
Subject: [MARCEDIT-L] deleting blank line between two tags in same record
Hello,
I have a batch of 13,000+ records which have a blank line between tags 830 & 856. Is there a way to remove these blank lines globally WITHOUT also removing the legitimate blank line between each record?
I've searched the archived posts and did not see a suggested solution for similar problems which can be applied to my situation.
I've tried the Notepad++ Text FX plug-in to delete blank lines, but that removed ALL blank lines, including the one which separates each record.
The extra blank lines were created when a tag 856 was deleted from the batch of records using regular expressions. I didn't think I could use the Add/Delete Field tool in MarcEditor to delete those particular 856 fields because each 856 slated for removal contained a different 8 digit string at the end of the tag.
Do I need to add something to the regular expression I used to identify the 856 tags in order to also remove the blank line left behind by the deleted 856? But again, I searched various regex help lists & blogs for help on how to do this, but came up with nothing that worked.
The regular expression used to locate all the unwanted 856 looked like this (probably something a lot simpler is available, but I'm really new at this!):
(=856 ..)(.*{2\$zAn electronic book accessible through the World Wide Web; click to view:$uhttp://site.ebrary.com/lib/twuca/Doc?id=})(\d{8})
To recap, I'd like to remove the blank line between the last 830 and the first 856 fields, but keep the blank line between each tag 999 and each =LDR. A sample from the batch of records I'm working with is copied below.
If anyone have some ideas, I would be so grateful to hear them. Thank you!
=LDR 03351nam 22006373i 4500
=001 ebr11188540
=003 CaPaEBR
=005 20160413011630.0
=006 m\\\\\o\\d\\\\\\\\
=007 cr\cn||||||n||
=008 160407s2016\\\\onca\\\\ob\\\\000\0\eng\d
=020 \\$z9781926789101$qprint
=035 \\$a(OOCEL)10047867
=035 \\$a(OCoLC)946888967
=035 \\$a(CaBNVSL)gtp00565426
=040 \\$aCaBNVSL$beng$erda$cCaBNVSL$dCaBNVSL
=043 \\$an-cn---
=050 \4$aRA643.86.C2$bV36 2016eb
=082 04$a362.1969792$222
=100 1\$aVan der Meulen, Emily,$d1977-$eauthor.
=245 10$aOn point :$brecommendations for prison-based needle and syringe programs in Canada /$cprepared by Emily van der Meulen, St{acute}ephanie Claivaz-Loranger, Seth Clarke, Annika Ollner, Tara Marie Watson.
=246 10$aRecommendations for prison-based needle and syringe programs in Canada.
=264 \1$a[Toronto, Ontario] :$b[Canadian HIV/AIDS Legal Network],$c2016.
=264 \2$aOttawa, Ontario :$bCanadian Electronic Library,$c2016.
=300 \\$a1 PDF (38 pages) :$billustrations.
=336 \\$atext$2rdacontent
=337 \\$aelectronic$2isbdmedia
=338 \\$aonline resource$2rdacarrier
=500 \\$a"January 2016."
=500 \\$a"This research was generously supported by PASAN, Canadian HIV/AIDS Legal Network, Ontario HIV Treatment Network, Native Youth Sexual Health Network, Department of Criminology, Ryerson University, Office of the Dean of Arts, Ryerson University"--back cover.
=500 \\$aIssued as part of the Canadian Electronic Library, Documents collection, Canadian health research collection, and Canadian public policy collection.
=504 \\$aIncludes bibliographical references (pages 36-37).
=506 \\$aAccess restricted to authorized users and institutions.
=538 \\$aMode of access: World Wide Web.
=588 \\$aTitle from cover.
=650 \0$aNeedle exchange programs$zCanada.
=650 \0$aPrisoners$xDrug use$zCanada.
=650 \0$aAIDS (Disease)$xPrevention$zCanada.
=650 \0$aHIV infections$xPrevention$zCanada.
=655 \0$aElectronic books.
=700 1\$aClaivaz-Loranger, St{acute}ephanie,$eauthor.
=700 1\$aClarke, Seth,$eauthor.
=700 1\$aOllner, Annika,$eauthor.
=700 1\$aWatson, Tara Marie,$eauthor.
=710 2\$aCanadian Electronic Library (Firm). Canadian Health Research Collection.
=710 2\$aCanadian HIV/AIDS Legal Network,$eissuing body.
=710 2\$aCanadian Electronic Library (Firm),$edistributor
=776 08$iPrint version:$z9781926789101
=830 \0$aCanadian Electronic Library.$pDocuments collection.
=830 \0$aCanadian Electronic Library.$pCanadian public policy collection.
=830 \0$aCanadian Electronic Library.$pCanadian health research collection.
=856 48$3Thumbnail cover image:$uhttps://ezproxy.student.twu.ca/login?url=http://files.deslibris.ca/covers/1004/10047867.jpg
=856 48$3Medium cover image:$uhttps://ezproxy.student.twu.ca/login?url=http://files.deslibris.ca/covers-medium/1004/10047867.jpg
=856 40$3desLibris e-book:$uhttps://ezproxy.student.twu.ca/login?url=http://deslibris.ca/ID/10047867
=999 \\$aClick on Weblink$hEGOVPUB$xEGOVPUBSUB$zCELHLTHRES
=LDR 02838nam 22005773i 4500
=001 ebr11188626
=003 CaPaEBR
=005 20160413005817.0
=006 m\\\\\o\\d\\\\\\\\
=007 cr\cn||||||n||
=008 160313s2016\\\\quc\\\\\ob\\\\000\0\eng\d
=020 \\$a9780886453510$qelectronic
=020 \\$z9780886453527$qprint
=035 \\$a(OOCEL)10049054
=035 \\$a(OCoLC)946888692
=035 \\$a(CaBNVSL)gtp00565391
=040 \\$aCaBNVSL$beng$erda$cCaBNVSL$dCaBNVSL
=043 \\$an-cn-on
=050 \4$aRA564.8$b.W545 2016eb
=082 04$a362.1609713$223
=100 1\$aWilliams, A. Paul,$d1951-$eauthor.
=245 10$aIntegrating long-term care into a community-based continuum :$bshifting from "beds" to "places" /$cA. Paul Williams, Janet Lum, Frances Morton-Chang, Kerry Kuluski, Allie Peckham, Natalie Warrick, Alvin Ying.
=264 \1$aMontreal, Qu{acute}ebec :$bIRPP,$c2016.
=264 \2$aOttawa, Ontario :$bCanadian Electronic Library,$c2016.
=300 \\$a1 PDF (43 pages).
=336 \\$atext$2rdacontent
=337 \\$aelectronic$2isbdmedia
=338 \\$aonline resource$2rdacarrier
=490 1\$aIRPP study,$x1920-9436 ;$vno. 59
=500 \\$a"February 2016".
=500 \\$aIssued as part of the Canadian Electronic Library, Documents collection, Canadian health research collection, and Canadian public policy collection.
=504 \\$aIncludes bibliographical references (pages 39-43).
=506 \\$aAccess restricted to authorized users and institutions.
=538 \\$aMode of access: World Wide Web.
=588 \\$aCover title.
=650 \0$aOlder people$xLong-term care$zOntario.
=650 \0$aCommunity health services for older people$zOntario.
=655 \0$aElectronic books.
=710 2\$aCanadian Electronic Library (Firm). Canadian Health Research Collection.
=710 2\$aInstitute for Research on Public Policy,$eissuing body.
=710 2\$aCanadian Electronic Library (Firm),$edistributor
=776 08$iPrint version:$z9780886453527
=830 \0$aIRPP study ;$vno. 59.$x1920-9436
=830 \0$aCanadian Electronic Library.$pDocuments collection.
=830 \0$aCanadian Electronic Library.$pCanadian public policy collection.
=830 \0$aCanadian Electronic Library.$pCanadian health research collection.
=856 48$3Thumbnail cover image:$uhttps://ezproxy.student.twu.ca/login?url=http://files.deslibris.ca/covers/1004/10049054.jpg
=856 48$3Medium cover image:$uhttps://ezproxy.student.twu.ca/login?url=http://files.deslibris.ca/covers-medium/1004/10049054.jpg
=856 40$3desLibris e-book:$uhttps://ezproxy.student.twu.ca/login?url=http://deslibris.ca/ID/10049054
=999 \\$aClick on Weblink$hEGOVPUB$xEGOVPUBSUB$zCELHLTHRES
=LDR 03528nam 22006973i 4500
Shirley Lee
Assistant Librarian, Systems, Acquisition & Interlibrary Loan Norma Marion Alloway Library | Trinity Western University
7600 Glover Road Langley, BC V2Y 1Y1
[log in to unmask] | Tel: 604-513-2121 x3914 Fax: 604-513-2063
www.twu.ca/library
________________________________________________________________________
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]
|