
Adding Large Type, Periodicals and Games GMDs to 245 Tags. Changing Photo Number and Barcode to 949 Field. Historical Photo Spreadsheet and Notetab Data Formulas. Stripping non lcsh/gsafd/bidex subject headings. Extract search keys from MARC text record (full set). Change data back from single lines to MARC text records. Finding primary language of work in 008. NoteTab Pro: Regular Expressions (RegEx) for changing a MARC text file into a spreadsheet. Formulas for upgrading and manipulating records in Excel and NoteTab ++. Note that each of these apps handle certain aspects of regex differently, and in for large MARC files in particular, working in the the MARC mnemonic in Notepad++ is often easier and faster than in the MarcEdit MARC editor. For Calc, the LibreOffice Help site has good info (and of course, there videos on YouTube). Microsoft also hosts a good general reference: Regular Expression Language - Quick Referenceįor other application-specific instructions, there are also a number of decent videos on using RegEx in Notepad++ and a useful cheatsheet. The reference section is particularly good for answering syntax questions. The tutorial suggests using EditPad Pro, but Notepad++ will work just fine if you want to try the various exercises. The excellent site includes a general intro to regex and a good tutorial at.
MarcEdit itself includes access to the Regular Expressions Store, where users have posted expressions that can be incorporated into task lists or for one-off searches. They are one of our most powerful tools for finding and manipulating character strings in MARC records, spreadsheets and text documents.Īs a decent starting point, Terry Reese has a MarcEdit RegEx primer, as well a number of videos on using RegEx for MarcEdit. A Regular Expression or regex for short, is a pattern describing a certain amount of text (defined broadly as including any character).