This is an excel problem. MarcEdit pulls data using Excel's OBDC
connection, and Excel's predictive typing likely sees that most data in your
spreadsheet is within the varchar range, so it configures the data stream
marcedit see's as such. You have to explicitly type your data. It requires
a data conversion. You do it like this:
http://marcedit.reeset.net/correct-isbns-converted-to-scientific-notation-in
-excel
--tr
-----Original Message-----
From: MarcEdit support in technical and instructional matters
[mailto:[log in to unmask]] On Behalf Of Bruce Eames
Sent: Wednesday, August 10, 2016 10:30 PM
To: [log in to unmask]
Subject: [MARCEDIT-L] Delimited text translator truncating long field?
Hi All,
The delimited text translator seems to be truncating longer fields .
Example - this is a long subtitle which was in the spreadsheet -
secundum jura gentium, romanorum leges, & imperij germanici constitutiones
sine noxa instituendo : von Durchzuegen der Kriegs-Voelker ... quoties
milites, quavis occasione, aut quocunq : tempore, per aliorum territoria,
aut sines aliquis ducere velit, transitus hujusmodi instituatur ejus, adqvem
milites pertinent, sumptu, sine malesicio, damno & noxa eorum per quorum
territoria ducuntur.
This is what came out in the MARC file -
secundum jura gentium, romanorum leges, & imperij germanici constitutiones
sine noxa instituendo : von Durchzuegen der Kriegs-Voelker ... quoties
milites, quavis occasione, aut quocunq : tempore, per aliorum territoria,
aut sines aliquis ducere velit, tr
When I look at the whole 245 field it comes to 350 characters exactly (with
spaces) so I wonder if this is a maximum?
Thanks so much,
Bruce.
********************
Bruce Eames | Library Systems Administrator ILMS / BONUS+ Coordinator
ArticleReach Direct Coordinator The University of Melbourne | University
Library Level 4, Thomas Cherry Building (Building 201) The University of
Melbourne, Victoria 3010, Australia T +61 3 8344 4236 E [log in to unmask]
W www.library.unimelb.edu.au
********************
This email and any attachments may contain personal information or
information that is otherwise confidential or the subject of copyright. Any
use, disclosure or copying of any part of it is prohibited. The University
does not warrant that this email or any attachments are free from viruses or
defects. Please check any attachments for viruses and defects before opening
them. If this email is received in error please delete it and notify us by
return email.
________________________________________________________________________
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]
|