Extract a spreadsheet from MarcEdit batch file; then search numbers using Sierra Create Lists

10/27/2023

Example: extracting 024 (and a few other check fields) to search an earlier form of 001 standard number for Alexander Street Press video delete files

In MarcEdit: tools->Export->Export Tab Delimited Records

Open

Open

Open from Excel

• Open; navigate to new file (This PC); then whereever you parked your file

• Choose All files in dropdown

If we needed the messes up numbers: Right click, choose Format cells;

scroll down to missing ASPs

highlight the missing ASP old control numbers and move into missing 024’s

Now, copy new column of 024 old-style control numbers and paste into Notebook or similar text file

save that file:

Sierra; Create Lists;

choose an EMPTY line; don’t forget, or you could erase someone else’s work

Import file; using Index -> control number

Click on Load:

Once all the ASP numbers are loaded; click Import