Tech Blog

A script for creating a report of invalid subfields

  • DescriptionA small Perl script that can be used to generate a report of invalid subfield codes for cataloguers to check.The script runs on the server and creates a report of BIB records that have non-alphanumeric subfield codes. It does not validate subfields per field, but tries to find cases where the code is definitely invalid.
  • Author: Ere Maijala
  • Additional author(s):
  • Institution: None
  • Year: 2009
  • License: MPL 1.1 / GPL 2.0
  • Short description: Use, modification and distribution of the code are permitted provided the copyright notice, list of conditions and disclaimer appear in all related material.
  • Link to terms: MPL 1.1, GPL 2.0
  • Skill required for using this code: basic



Programming language


Software requirements



Version 1.2

Using the following Ex Libris open interfaces

None. Direct Oracle connection using read-only user name/password.


Version 1.2

  • Added check for empty subfields

Version 1.1

  • Initial public release.

Installation instructions

Copy the script to the server (make sure not to introduce DOS/Windows line endings to the file), make it executable and check the database settings if your Oracle is not in /oracle/app/oracle/product/9.2.0.

TO DO list

  • Field-based validation of allowed subfields?


Leave a Reply