Fantastic - thanks Terry
********************
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.
-----Original Message-----
From: MarcEdit support in technical and instructional matters [mailto:[log in to unmask]] On Behalf Of Terry Reese
Sent: Thursday, 11 August 2016 1:01 PM
To: [log in to unmask]
Subject: Re: [MARCEDIT-L] Delimited text translator truncating long field?
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]
________________________________________________________________________
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]
|