MARCEDIT-L Archives

March 2012

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:
Mark Ehlert <[log in to unmask]>
Reply To:
MarcEdit support in technical and instructional matters <[log in to unmask]>
Date:
Thu, 22 Mar 2012 14:30:43 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (26 lines)
If you want to massage the data in Excel, the following formula might
work (assuming your number list is in column A and the formula posted
to the column B):

=IF((LEN(A2)<=8), "ocm"&REPT("0",(8-(LEN(A2))))&A2, "")

If the length of the number in A2 is equal to or less than 8, then add
ocm with leading zeros and the number in A2 so the new number is 11
characters long.  Any number under the A column that is more than 8
characters gets a blank in the related B cell.

I tested this on several some random numbers and it appears to work,
but caveat cataloger.

--
Mark K. Ehlert                 Minitex
Coordinator                    University of Minnesota
Bibliographic & Technical      15 Andersen Library
  Services (BATS) Unit         222 21st Avenue South
Phone: 612-624-0805            Minneapolis, MN 55455-0439
<http://www.minitex.umn.edu/>

________________________________________________________________________

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