Answer

It won't hurt anything to try, and it can work pretty well. 

Instructions

These instructions are written for Microsoft Word and Excel, and assume the computer experience necessary to follow the steps.

  1. In the normal view of your list in the old catalog (not the emailed or print format, just the first view of the page), select the text of your entire list and copy it (Ctrl-C).
  2. Paste into a new Word document as plain text ("keep text only")
  3. Using find and replace, edit to place titles into a consistent position within lines:
    1. Start at the top of the document. Use Replace All: find – Details | replace – nothing (leave blank) 
    2. Start at the top of the document. Use Replace All: find – ^p followed by 5 spaces | replace – ^t
    3. Start at the top of the document. Use Replace All: find – ^p^p | replace – ^p
  4. Save as plain text (change file type to *.txt and accept defaults in dialog)
  5. In Excel open the file with the text file wizard, as tab delimited.
  6. The titles should appear in one column, authors in a different column. You could have one out of place but hopefully most of them are in a column. Select the titles, copy (Ctrl-C).
  7. In the new catalog, in a list you've created, use the Add Multiple Titles button. Paste into that box and Add to List.

After completion

You should do an item-by-item check between your two lists because sometimes a different item with a similar title is substituted for the one you wanted.

Topics

  • Last Updated Aug 12, 2022
  • Views 125

Submit a Question

Fields marked with * are required.