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:
Terry Reese <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Fri, 12 Dec 2014 13:39:12 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (59 lines)
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]

ATOM RSS1 RSS2