You can also copy and paste the file into Word and do a Find and Replace:
Find: ^p^p=856
Replace: ^p=856
That's only going to pick up a blank line before the 856.
Timothy H. Gatti
Manager of Technical Services
BRYAN CAVE LLP
T: +1 314 259 2732
[log in to unmask]
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Meehan, Thomas
Sent: Thursday, September 29, 2016 2:58 AM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] deleting blank line between two tags in same record
Shirley,
If you still have to deal with the file with blank lines in (i.e. you can't redo it as Terry suggests), the following might work in Notepad++
Search for: (=830[^\n]*?)\n\r
Replace with: $1
This worked on the sample below I copied into Notepad++, but would obviously need careful checking.
Thanks,
Tom
---
Thomas Meehan
Head of Cataloguing and Metadata
University College London
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Terry Reese
Sent: 29 September 2016 01:27
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] deleting blank line between two tags in same record
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]
________________________________________________________________________
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 electronic message is from a law firm. It may contain confidential or privileged information. If you received this transmission in error, please reply to the sender to advise of the error and delete this transmission and any attachments.
bcllp2016
________________________________________________________________________
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]
|
