Extract a spreadsheet from MarcEdit batch file; then search numbers using Sierra Create Lists
- Melanie Shaw
Owned by Melanie Shaw
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 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