Subject: | |
From: | |
Reply To: | |
Date: | Fri, 12 Dec 2014 12:10:10 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
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]
|
|
|