Thank you, Terry, that worked nicely. Copy field and REGEX did the trick!
Best wishes,
Alasdair.
------------------------------
Date: Tue, 10 Jul 2018 15:28:01 +0000
From: MACDONALD Alasdair <[log in to unmask]>
Subject: Using the build new field function - how to create multiple fields?
The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336.
________________________________________________________________________
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]
------------------------------
Date: Tue, 10 Jul 2018 12:11:06 -0400
From: Terry Reese <[log in to unmask]>
Subject: Re: Using the build new field function - how to create multiple fields?
This is not how the build new field works. The build new field builds *one* new field. It does not do this kind of processing across multiple fields.
What you actually want is the copy field, using a regular expression. This will do what you are looking for. When I use this:
I get back this:
=LDR 00636cam a22002173u 4500
=001 010426356
=003 Uk
=005 20100419085548.0
=008 930519s1993\\\\enka\\\||\\\\\000\||eng\\
=019 a\$aG02060631
=020 \\$a1853391948 (pbk)
=020 \\$a1853392081
=035 \\$a(StEdU)1853391948 (pbk)
=035 \\$a(StEdU)1853392081
=040 \\$aWhitaker$dUk
=100 1\$aChambers, Robert,$d1932-
=245 00$aChallenging the professions :$bfrontiers for rural development /$cRobert Chambers.
=260 \\$bIntermediate Technology Publications,$c1993.
=336 \\$atext$2rdacontent
=337 \\$aunmediated$2rdamedia
=338 \\$avolume$2rdacarrier
=852 41$aBritish Library$bDSC$j93/15557
From: MarcEdit support in technical and instructional matters <[log in to unmask]> On Behalf Of MACDONALD Alasdair
Sent: Tuesday, July 10, 2018 11:28 AM
To: [log in to unmask]
Subject: [MARCEDIT-L] Using the build new field function - how to create multiple fields?
Hello everyone,
I appear to have got stuck trying to copy some ISBNs into a new 035 field.
Bit of a long story as to why I want to do this, involving an e-book collection with no supplied metadata other than an Excel document and trying to mine the British Library for print records that I can then morph into e-book format.
What I am trying to do is make every 020 $a into an 035 with our institutional code as a prefix. This will then give me a unique matching point for Alma to overlay some stub records I have made from the Excel doc without bumping any print versions that we might hold. I can knock the qualifier information off in the 035 using a REGEX easily enough, but I need MARCEdit to make me an 035 for each instance of the 020. It only seems to want to do this for the first one. What I don't know is if the match points I have made on my stub records are for the HBK or PBK printing, so I need a separate 035 for all ISBNs.
I don't know if I have missed something, but just can't get it to work.
Example below. The pattern I used in the Build New Fields GUI was:
=035 <file://$a(StEdU)%7b020$a%7d> \\$a(StEdU){020$a}
Thanks in advance if anyone can help.
Alasdair.
=LDR 00636cam a22002173u 4500
=001 010426356
=003 Uk
=005 20100419085548.0
=008 930519s1993\\\\enka\\\||\\\\\000\||eng\\
=019 a\$aG02060631
=020 \\$a1853391948 <file://$a1853391948> (pbk)
=020 \\$a1853392081 <file://$a1853392081>
=035 \\$a(StEdU)1853391948 <file://$a(StEdU)1853391948> (pbk)
=040 \\$aWhitaker$dUk <file://$aWhitaker$dUk>
=100 1\$aChambers, Robert,$d1932-
=245 00$aChallenging the professions :$bfrontiers for rural development /$cRobert Chambers.
=260 \\$bIntermediate <file://$bIntermediate> Technology Publications,$c1993.
=336 \\$atext$2rdacontent <file://$atext$2rdacontent>
=337 \\$aunmediated$2rdamedia <file://$aunmediated$2rdamedia>
=338 \\$avolume$2rdacarrier <file://$avolume$2rdacarrier>
=852 41$aBritish Library$bDSC$j93/15557
*****
Alasdair MacDonald
Metadata Co-ordinator,
Edinburgh University Library,
George Square,
Edinburgh,
EH8 9LJ.
E-mail: [log in to unmask] <mailto:[log in to unmask]>
Tel.: +44 (0)131 651 3801
________________________________________________________________________
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]
<mailto:[log in to unmask]> . To unsubscribe, send a message "SIGNOFF MARCEDIT-L" to [log in to unmask] <mailto:[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]
------------------------------
End of MARCEDIT-L Digest - 9 Jul 2018 to 10 Jul 2018 (#2018-166)
****************************************************************
--
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.
________________________________________________________________________
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]
|