Amy,
Thanks for the feedback. Yes -- in the current implementation of the
Tab Delimited Export Tool -- duplicated fields are placed in a single
column, delineated with, I believe, character 0x30 -- not idea -- but
again, when I was first putting this together, it was easy. I'd be
willing to make this function work better, again if folks had
suggestions.
In terms of your other question:
> PS. Can you help me with the scripting to integrate a list of URLs
with
> the MARC records?
I likely could. I'd sent you a sample script -- my guess is that if I
had the two files, I could use that script (maybe with a few small
tweaks) to make it work.
--TR
> -----Original Message-----
> From: MarcEdit support in technical and instructional matters
> [mailto:[log in to unmask]] On Behalf Of Amy Nadell
> Sent: Monday, November 23, 2009 10:28 AM
> To: [log in to unmask]
> Subject: Re: Question related to Exported MARC Records into Excel
> (potential new function in MarcEdit)
>
> Hi Terry,
>
> Thanks for asking!
> I recently had to prepare a demonstration of subject fields, 650, 655,
> 700 for a (non-cataloging) client and the MARC to delimited format was
> a
> bit cumbersome. In the end, I added additional delimiters (available
> in
> excel) to get the results I wanted, however the columns/headers did
not
> match up I had to create separate spreadsheets and then combine. The
> fields which are not repeatable came out great but the repeatable
> fields
> were messy. I don't think that 0-999 fields and subfields listed in
> columns is terrible, not if you know your fields well enough. I spoke
> with a database professional who suggested that the first record have
> as
> many possible columns as might appear in the rest of the records set.
> His assumption was that if a subsequent record had less 650s than an
> empty cell would be created. Instead MarcEdit fills every cell
> regardless of the indicated header.
>
> I hope that has helped. Sorry I do not have any other program
> suggestions.
> As I have said in the past, "I am great at cutting and pasting!"
>
> PS. Can you help me with the scripting to integrate a list of URLs
with
> the MARC records?
>
> Thanks!!!!!
> Amy
>
>
_______________________________________________________________________
> _
>
> 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 MARCEDIT-L-
> [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]
|