001 field: create an 001 using 035 field and OCLC Connexion

In MarcEdit

1-Make a new 001 field (briefly)

• Delete the incorrect 001 fields using Add/Delete Field

• 

• Go to Tools; Build a New Field:

• =001 {035$a} ← 2 spaces exactly in front of curly brackets

2-Go to Tools; Edit Field Data:

• Field: 001 Find: (OCoLC)

• Position: [blank] Replace: on

  

• Save

Unfortunately, OCLC 001 number prefixes vary according to length:

We can look at them to make sure they do fall into the differing sets of OCLC prefixes:

4-While the Find all: =001 search screen is open

• 

• Find the copy icon in the lower left side and click on it

  

5-Excel

• And paste the copied find all text

• 

Copy the cleaned up column of OCLC nos.

• Open Notepad and paste in the column

• Save it with an easy to find name

CONNEXION

Batch; Enter bibliographjic search keys

• Import; then find the text file

• Save the Search keys: and Close

• If you have an empty Local Save File, go on to next step, otherwise, stop and create on in Local File Manager

Batch; Process Batch:

• 

• Select your Save file

• Select Online Searches

• OK

• 

  This will take a few minutes, so head back to MarcEdit

  • Delete the temporary 001 fields created in step 1.

  • Save;

  • then check progress on the OCLC Batch Search

• When OCLC finishes, a summary screen will come up with the results:

• Do an F3 search of the local save file; select first bib; scroll to the end and Ctrl-Shift-Click to select entire file

• Export and give it an easy to find name: OCLCforGPOpilot001s or similar

• It will have the suffix of .dat

MarcEdit

If you MarcBreak it, you will see the lovely prefixed 001s

• Close MarcEditor

Tools; Merge Records

• 

• 

• Source file: the oclc records

• Merge file: the GPO pilot project records (with deleted 001s)

• Save file: the new merged file

• Next

  • Select the 001 field only

  • 

Edit records

• Would you look at that!