<html>
<body>
At 03:38 PM 11/29/2010 -0500, Chris Nighswonger wrote:<br>
<blockquote type=cite class=cite cite>On Mon, Nov 29, 2010 at 3:31 PM,
Owen Leonard
<<a href="mailto:oleonard@myacpl.org">oleonard@myacpl.org</a>>
wrote:<br>
<dl>
<dd>... The bad news is you'll still have to update your<br>
<dd>spreadsheets to replace phrases like "marine biology" with
a<br>
<dd>corresponding less-than-10-letter code.<br>
</dl><br>
The not-so-bad-news is that you could whip up a Perl script to parse
through your spreadsheets and add the additional column along with
populating it properly.</blockquote><br>
and Susan Bennett added <br>
<blockquote type=cite class=cite cite>I may be wrong, so anyone out there
with more knowledge please correct, but I don't think you can use spaces
in the ccode so changing the length wont help. Can't you do a simple find
and replace?</blockquote><br>
First, are spaces allowed in the 10 character CCODE? Are there any other
restrictions (numerics, underlines, hyphens, etc)? I find nothing
(easily) in the documentation. As a comparison, the LOC code allows 80
characters including (at least) spaces.<br><br>
For various historical reasons we have nearly two hundred
"categories" spread across 468 spreadsheets - that would be a
possible 100,000 "simple search and replace" operations
;={ and I've never had much success with Perl looking for entries
in a specific column of a spreadsheet where obviously the "category
name" could also appear in the title, keywords and reviews which we
obviously do not want to modify.<br><br>
So I'll probably end up attempting to modify the SQL parameter for field
length (a task which, from past experience with Oracle, I am not looking
forward to.)<br><br>
This is the first major hiccough we have encountered with the data
migration and at the moment is a show-blocker.<br><br>
Thanks to you all - all suggestions, etc are warmly welcomed.<br><br>
Paul</body>
</html>