Extract a tab-delimitted file to Excel, then search in Sierra

10/27/2023

Example: extracting 024 to search an earlier form of 001 standard number for Alexander Street Press video delete files

In MarcEdit: tools; Export;

Export Tab Delimited Records

In Excel

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

Choose All files in dropdown

Right click, choose Format cells;

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

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

Sierra; Create Lists;

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

Import file; using Index -> control number