Why not just convert to Marc text (using Marcbreaker), then
batch-change '\n=([0-9])' to '\t=$1' in any text editor of your choice?
Or in powergrep or perl or whatever. Since the character encoding
at that point consists of {-delimited strings, you probably won't
mess it up without trying to, though with Excel you never know--I
avoid it at all costs: I tend to stick to text editors, where you're
less
likely to be taken by surprise. pfs
On Thu, Apr 6, 2017, at 08:26, Edward Potten wrote:
> Hi All
>
>
> I'm working with a batch of about 100,000 MARC records which I need to
> play around with in various ways, so am wanting to export it out into
> Excel, which has powerful sorting, find and replace options, then
> re-import it and convert back to a MARC file.
>
>
> 1) Is there a way of getting MarcEdit to automatically export all MARC
> fields it finds in a file, rather than individually selecting those I
> want outputting?
>
>
> 2) Is there a way of getting MarcEdit to export multiple instances of a
> single field as delimited fields, rather than batching them all up?
> [i.e.: if I have six 500 notes I'd like these exported as six separate
> delimited notes rather than drawing together into one].
>
>
> 3) Will all this to-ing and fro-ing mess up the character encoding?
>
>
> Any advice much appreciated.
>
> Thanks
>
> Ed
>
>
> ________________________________________________________________________
>
> 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]
--
Paul Schaffner UM Library : Digital Content & Collections
[log in to unmask] | http://www.umich.edu/~pfs/
________________________________________________________________________
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]
|