MARCEDIT-L Archives

December 2014

MARCEDIT-L@LISTSERV.GMU.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Jeff Edmunds <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Fri, 12 Dec 2014 12:10:10 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (45 lines)
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]

ATOM RSS1 RSS2