Subject: | |
From: | |
Reply To: | |
Date: | Fri, 12 Dec 2014 13:39:12 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
You need to join the fields. After defining the fields, in the arguments list, select each of these fields that will need to be joined, then right click and select join items.
--tr
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Jeff Edmunds
Sent: Friday, December 12, 2014 12:10 PM
To: [log in to unmask]
Subject: [MARCEDIT-L] concatenating subfields in Delimited Text Translator
All,
The spreadsheet to be converted to a (very basic) MARC record contains a column with OCLC number (which I want to end up in the 001) and then a series of columns with holdings data elements, all of which I want to end up in separate subfields of the 949 field. When I use the Delimited Text Translator with arguments as follows:
0 001 0
1 949$i 0
2 949$a 0
3 949$w 0
etc.
I end up multiple 949 fields rather than one 949 field with the subfields concatenated.
In other words, the .mrk file spat out looks like this:
=LDR 00000nam a2200000Ia 45e0
=001 889521290
=008 141212s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=949 \\$aTD898.118.B76 2014
=949 \\$i000075497422
=949 \\$kIN-MARKING
=949 \\$lUP-PAT
=949 \\$mIN-MARKING
=949 \\$rY
=949 \\$sY
=949 \\$tBOOK
=949 \\$wLC
rather than like this:
=LDR 00000nam a2200000Ia 45e0
=001 889521290
=008 141212s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=949 \\$aTD898.118.B76 2014$i000075497422$kIN-MARKING$lUP-PAT$mIN-MARKING$rY$sY$tBOOK$wLC
Is there a way to achieve the concatenation WITHIN the Delimited Text Translator, or do I have to collapse the multiple 949s into a single 949 using a separate step (and if so, what would that step be)?
Thanks,
Jeff
________________________________________________________________________
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]
|
|
|