SlideShare a Scribd company logo
1 of 33
Working With the
Editor
What can I use
MarcEdit for?
A few things MarcEdit can help users:
1. Automate processing of vendor MARC records for e-records
2. Facilitate large data clean up projects, like updating subject or name authorities
3. Converting AACR2 data to Hybrid-RDA records (true RDA conversion isn’t just
about field changes, but requires a reassessment of the content)
4. Convert data from non-MARC formats like Dublin Core, MODS, EAD, MARCXML, or
other XML or JSON formats to MARC or from MARC to various non-MARC formats
5. Reconcile MARC data to utilize Linked data concepts
6. Validate records
7. Join or Split large data sets
8. Manage Character encodings and Unicode Normalizations
9. Integration with OCLC and ILS systems
10. Merging data between data sets or data files
11. Retrieve data from remote sources through OAI, Z39.50, SRU, Atom Pub, etc.
I have
Records….
Editing in MarcEdit
Workflow process looks like…
1. Validate Records for initial errors (or targeted review)
2. “Break MARC data to mnemonic”
3. Open “broken” records into the MarcEditor
4. Perform Global Edits to clean your data
5. Save your changes
6. “Compile” your records back to MARC for addition into your ILS
Create your own Validation fields
MarcEdit can open records directly into the Editor
Automate your changes
Ingest records directly through
integrations with supported ILS
systems like Koha, Alma, Evergreen,
and OCLC.
Demonstration
How do I get
started?
1. MarcEdit 101 Webinar Series:
marcedit.reeset.net/marcedit-101-workshop
2. Knowledge-base Items:
marcedit.reeset.net/archives/category/knowledge_base
3. Tutorials: marcedit.reeset.net/tutorials
4. Sample Lesson Plan (In development):
github.com/reeset/marcedit_sample_lesson_plan
How do I get
help?
MarcEdit Listserv
URL: http://listserv.gmu.edu/cgi-bin/wa?A0=marcedit-l
The MarcEdit Listserv is hosted by George Mason University and
provides users an opportunity to send questions to the MarcEdit
user community. What’s more, the list includes a searchable archive.
Contact the Author:
URL: reeset@gmail.com
I’m always open to people contacting me and asking questions.
Built-in Help
Preferences
Addressing
Unicode
Normalization
Fragmentation
How Does MarcEdit 7 Address this?
Through the Preferences
Edit Shortcuts
Edit Shortcuts tend to have the following characteristics:
◦ Could be MARC21 Specific
◦ Represent items that could be written as regular expressions, but expressions that are difficult to write
◦ Require mathematical or data conversions
◦ Are more one-off functions than “global tools”
◦ Often can be added to tasks.
Editing MARC –
Find/Replace
Works like a normal Find/Replace in
most Textpad utilities.
Unlike most Textpads, Replace
supports UTF-8 (when working with
UTF-8 files) and regular expressions.
Conditional
Replacements
Editing MARC –
Find All
Find all function was designed for use
with the Paging mode
Allows users to find any text across all
pages
Generates a jump list that can be used
to find individual records for edit
Miscellaneous
Tools
Generate Cutters (sanborn and other)
Generate Record from URL (one a website, one from LC)
Editing MARC –
Global
Add/Delete
Field
Globally add fields to all MARC records
◦ Allows users to set insertion
position.
Globally delete fields
◦ Allows global delete
◦ Allows conditional delete
Supports Regular Expressions
Editing MARC – Modifying subfield data
Allows for the modification
of variable MARC field
subfield data (MARC fields
>10)
Allows for the modification
of control field data by
position or range of positions
Allows users to prepend and
append data to subfields.
Allows users to change
subfield tagging.
Editing MARC –
Modifying
subfield data
Allows users to insert new subfields
and define subfield placement.
Allows users to move field data from
one field to another.
Supports:
• UTF-8 with UTF-8 files
• Regular Expressions
• Adding new subfields.
Editing MARC –
Modifying
subfield data
Specify insertion position: https://marcedit.reeset.net/set-
subfield-insert-position
Editing MARC –
Swapping Fields
Swap parts of MARC Fields or entire
MARC fields
◦ Define field, indicator and
subfields to move.
◦ Can move field data and delete
the original field or clone the field
data and move the clone to the
new location.
◦ Can add data to an existing field.
Build New Field
Tool
Build New Field Tool
This method works well when needing
to build complex proxy statements
Build New Field
Modifier functions
◦ Find
◦ replace
◦ trim
◦ trimstart
◦ trimend
◦ substring
◦ Regex
All functions can be stacked except the find function. If you use
this function, it must be the first in the chain.
Example: =856 $a{090.find(“G42”).trim()}$zConnect to this
resource online.
Example: =901 $a{LDR.substring(6,1)}$b{904$a}$mDate:
{260$c.trim(“ .”)}
Character Conversions within the MarcEditor
MARCEDITOR ALLOWS USERS TO CONVERT CHARACTER DATA BETWEEN DIFFER ENT CHARACTERSETS.
Fixing Boo-boos
MarcEdit’s Special Undo
◦ Allows you to step back one global
change.
Sorting Fields
MarcEdit provides multiple sorting types:
◦ Control Number
◦ Sorts record position within the file
◦ Title
◦ Sorts record position within the file
◦ Author
◦ Sorts record position within the file
◦ Call Number
◦ Sorts record position within the file
◦ 0xx Fields
◦ Sorts the 0xx fields within individual records (does *not* change record position within a file)
◦ All Fields
◦ Sorts all fields within individual records (does *not* change record position within a file)
◦ Custom Sort
◦ Sorts all defined fields within individual records (does *not* change record position within a
file)
MARC Data
Reports
MarcEdit includes a number of validation/information
reports:
§ Field Count Reports
§ Including information related to indicator/subfield usage
§ Material Type Reports
§ Generate Reports and pull together records for each material type
§ Validate ISBN/ISSN Reports
§ Mathematically validates check digit
§ Validate Headings *NEW*
§ Validates all access points against LCSH and LC NAF
Field Counts
Field Count
◦ Provides a quick count of fields
◦ Report of subfields used within a
particular field
◦ Detailed reports of all
fields/subfields used within a
fileset.
Material Type
Report
Material Type Report
◦ Reports number of records by
material type
◦ Breaks down material type by sub-
types
◦ Utilizes the Leader, 008 and GMD
to determine format types
Validate ISSN/ISBN/Headings
In-Line
Validation
MarcValidator-lite
◦ Can access MarcValidator for quick
validation of data elements found
in the file set
◦ Validation can use any defined
rules set.
Change logging
MarcEdit provides the ability to log
changes made during global edits.
Logging isn’t enabled by default, and
is turned on via the Preferences
Once enabled, logs can be viewed,
managed, and enhanced.
Your Questions

More Related Content

What's hot

How the Postgres Query Optimizer Works
How the Postgres Query Optimizer WorksHow the Postgres Query Optimizer Works
How the Postgres Query Optimizer WorksEDB
 
Advanced REXX Programming Techniques
Advanced REXX Programming TechniquesAdvanced REXX Programming Techniques
Advanced REXX Programming TechniquesDan O'Dea
 
Oracle architecture with details-yogiji creations
Oracle architecture with details-yogiji creationsOracle architecture with details-yogiji creations
Oracle architecture with details-yogiji creationsYogiji Creations
 
A project on DBMS and RDMS
A project on DBMS and RDMSA project on DBMS and RDMS
A project on DBMS and RDMSAayush vohra
 
Understanding DB2 Optimizer
Understanding DB2 OptimizerUnderstanding DB2 Optimizer
Understanding DB2 Optimizerterraborealis
 
Presentation db2 best practices for optimal performance
Presentation   db2 best practices for optimal performancePresentation   db2 best practices for optimal performance
Presentation db2 best practices for optimal performancesolarisyougood
 

What's hot (8)

DB2 on Mainframe
DB2 on MainframeDB2 on Mainframe
DB2 on Mainframe
 
How the Postgres Query Optimizer Works
How the Postgres Query Optimizer WorksHow the Postgres Query Optimizer Works
How the Postgres Query Optimizer Works
 
Redis 101
Redis 101Redis 101
Redis 101
 
Advanced REXX Programming Techniques
Advanced REXX Programming TechniquesAdvanced REXX Programming Techniques
Advanced REXX Programming Techniques
 
Oracle architecture with details-yogiji creations
Oracle architecture with details-yogiji creationsOracle architecture with details-yogiji creations
Oracle architecture with details-yogiji creations
 
A project on DBMS and RDMS
A project on DBMS and RDMSA project on DBMS and RDMS
A project on DBMS and RDMS
 
Understanding DB2 Optimizer
Understanding DB2 OptimizerUnderstanding DB2 Optimizer
Understanding DB2 Optimizer
 
Presentation db2 best practices for optimal performance
Presentation   db2 best practices for optimal performancePresentation   db2 best practices for optimal performance
Presentation db2 best practices for optimal performance
 

Similar to Working with the MarcEditor

Make MarcEdit Work For You: OLC Technical Services Retreat
Make MarcEdit Work For You: OLC Technical Services RetreatMake MarcEdit Work For You: OLC Technical Services Retreat
Make MarcEdit Work For You: OLC Technical Services RetreatTerry Reese
 
marcedit_discussion.pdf
marcedit_discussion.pdfmarcedit_discussion.pdf
marcedit_discussion.pdfHOANGNGOCTUAN2
 
Marc edit and_nonmarc_data (1)
Marc edit and_nonmarc_data (1)Marc edit and_nonmarc_data (1)
Marc edit and_nonmarc_data (1)Anoop Kumar Bajpai
 
Terry Reese - Real-world data editing with MarcEdit
Terry Reese - Real-world data editing with MarcEditTerry Reese - Real-world data editing with MarcEdit
Terry Reese - Real-world data editing with MarcEditKohaGruppoItaliano
 
Making RDA Easy(er) with MarcEdit
Making RDA Easy(er) with MarcEditMaking RDA Easy(er) with MarcEdit
Making RDA Easy(er) with MarcEditTerry Reese
 
MarcEdit - makes the life easier (BALID Training programme on Marc 21)
MarcEdit - makes the life easier (BALID Training programme on Marc 21)MarcEdit - makes the life easier (BALID Training programme on Marc 21)
MarcEdit - makes the life easier (BALID Training programme on Marc 21)Md. Zahid Hossain Shoeb
 
OLC Batch Edit Panel: Specialized Tools for Batch Editing MarcEdit
OLC Batch Edit Panel: Specialized Tools for Batch Editing MarcEditOLC Batch Edit Panel: Specialized Tools for Batch Editing MarcEdit
OLC Batch Edit Panel: Specialized Tools for Batch Editing MarcEditTerry Reese
 
Dublin Core In Practice
Dublin Core In PracticeDublin Core In Practice
Dublin Core In PracticeMarcia Zeng
 
Spring data presentation
Spring data presentationSpring data presentation
Spring data presentationOleksii Usyk
 
47468272 introduction-to-informatica
47468272 introduction-to-informatica47468272 introduction-to-informatica
47468272 introduction-to-informaticaVenkat485
 
Indexator_oct2022.pdf
Indexator_oct2022.pdfIndexator_oct2022.pdf
Indexator_oct2022.pdfDaniel JACOB
 
UNIT - 1 Part 2: Data Warehousing and Data Mining
UNIT - 1 Part 2: Data Warehousing and Data MiningUNIT - 1 Part 2: Data Warehousing and Data Mining
UNIT - 1 Part 2: Data Warehousing and Data MiningNandakumar P
 
Micka Manual
Micka ManualMicka Manual
Micka ManualSDIEDU
 
Force11 JDDCP workshop presentation, @ Force2015, Oxford
Force11 JDDCP workshop presentation, @ Force2015, OxfordForce11 JDDCP workshop presentation, @ Force2015, Oxford
Force11 JDDCP workshop presentation, @ Force2015, OxfordMark Wilkinson
 
MarcEdit Shelter-In-Place Webinar 5: Working with MarcEdit's Linked Data Fram...
MarcEdit Shelter-In-Place Webinar 5: Working with MarcEdit's Linked Data Fram...MarcEdit Shelter-In-Place Webinar 5: Working with MarcEdit's Linked Data Fram...
MarcEdit Shelter-In-Place Webinar 5: Working with MarcEdit's Linked Data Fram...Terry Reese
 
MetaSuite productfolder- ETL-Tool für große Datenmengen
MetaSuite productfolder- ETL-Tool für große DatenmengenMetaSuite productfolder- ETL-Tool für große Datenmengen
MetaSuite productfolder- ETL-Tool für große DatenmengenMinerva SoftCare GmbH
 

Similar to Working with the MarcEditor (20)

Make MarcEdit Work For You: OLC Technical Services Retreat
Make MarcEdit Work For You: OLC Technical Services RetreatMake MarcEdit Work For You: OLC Technical Services Retreat
Make MarcEdit Work For You: OLC Technical Services Retreat
 
marcedit_discussion.pdf
marcedit_discussion.pdfmarcedit_discussion.pdf
marcedit_discussion.pdf
 
Marc edit and_nonmarc_data (1)
Marc edit and_nonmarc_data (1)Marc edit and_nonmarc_data (1)
Marc edit and_nonmarc_data (1)
 
Terry Reese - Real-world data editing with MarcEdit
Terry Reese - Real-world data editing with MarcEditTerry Reese - Real-world data editing with MarcEdit
Terry Reese - Real-world data editing with MarcEdit
 
Making RDA Easy(er) with MarcEdit
Making RDA Easy(er) with MarcEditMaking RDA Easy(er) with MarcEdit
Making RDA Easy(er) with MarcEdit
 
Metadata crosswalks
Metadata crosswalksMetadata crosswalks
Metadata crosswalks
 
MarcEdit - makes the life easier (BALID Training programme on Marc 21)
MarcEdit - makes the life easier (BALID Training programme on Marc 21)MarcEdit - makes the life easier (BALID Training programme on Marc 21)
MarcEdit - makes the life easier (BALID Training programme on Marc 21)
 
OLC Batch Edit Panel: Specialized Tools for Batch Editing MarcEdit
OLC Batch Edit Panel: Specialized Tools for Batch Editing MarcEditOLC Batch Edit Panel: Specialized Tools for Batch Editing MarcEdit
OLC Batch Edit Panel: Specialized Tools for Batch Editing MarcEdit
 
Dublin Core In Practice
Dublin Core In PracticeDublin Core In Practice
Dublin Core In Practice
 
Spring data presentation
Spring data presentationSpring data presentation
Spring data presentation
 
47468272 introduction-to-informatica
47468272 introduction-to-informatica47468272 introduction-to-informatica
47468272 introduction-to-informatica
 
CTDA MODS and Islandora XML Forms
CTDA MODS and Islandora XML FormsCTDA MODS and Islandora XML Forms
CTDA MODS and Islandora XML Forms
 
Indexator_oct2022.pdf
Indexator_oct2022.pdfIndexator_oct2022.pdf
Indexator_oct2022.pdf
 
UNIT - 1 Part 2: Data Warehousing and Data Mining
UNIT - 1 Part 2: Data Warehousing and Data MiningUNIT - 1 Part 2: Data Warehousing and Data Mining
UNIT - 1 Part 2: Data Warehousing and Data Mining
 
CADA
CADA CADA
CADA
 
Micka Manual
Micka ManualMicka Manual
Micka Manual
 
Force11 JDDCP workshop presentation, @ Force2015, Oxford
Force11 JDDCP workshop presentation, @ Force2015, OxfordForce11 JDDCP workshop presentation, @ Force2015, Oxford
Force11 JDDCP workshop presentation, @ Force2015, Oxford
 
MarcEdit Shelter-In-Place Webinar 5: Working with MarcEdit's Linked Data Fram...
MarcEdit Shelter-In-Place Webinar 5: Working with MarcEdit's Linked Data Fram...MarcEdit Shelter-In-Place Webinar 5: Working with MarcEdit's Linked Data Fram...
MarcEdit Shelter-In-Place Webinar 5: Working with MarcEdit's Linked Data Fram...
 
MetaSuite productfolder- ETL-Tool für große Datenmengen
MetaSuite productfolder- ETL-Tool für große DatenmengenMetaSuite productfolder- ETL-Tool für große Datenmengen
MetaSuite productfolder- ETL-Tool für große Datenmengen
 
Database fundamentals
Database fundamentalsDatabase fundamentals
Database fundamentals
 

More from Terry Reese

MarcEdit Shelter-In-Place Webinar 7: Making Regular Expressions work for you ...
MarcEdit Shelter-In-Place Webinar 7: Making Regular Expressions work for you ...MarcEdit Shelter-In-Place Webinar 7: Making Regular Expressions work for you ...
MarcEdit Shelter-In-Place Webinar 7: Making Regular Expressions work for you ...Terry Reese
 
MarcEdit Shelter-In-Place Webinar 6: Regular Expressions and .NET, A Primer
MarcEdit Shelter-In-Place Webinar 6: Regular Expressions and .NET, A PrimerMarcEdit Shelter-In-Place Webinar 6: Regular Expressions and .NET, A Primer
MarcEdit Shelter-In-Place Webinar 6: Regular Expressions and .NET, A PrimerTerry Reese
 
MarcEdit Shelter-In-Place Webinar 5.5: Transliterations in MarcEdit
MarcEdit Shelter-In-Place Webinar 5.5: Transliterations in MarcEditMarcEdit Shelter-In-Place Webinar 5.5: Transliterations in MarcEdit
MarcEdit Shelter-In-Place Webinar 5.5: Transliterations in MarcEditTerry Reese
 
MarcEdit Shelter-In-Place Webinar 4: Merging, Clustering, and Integrations…oh...
MarcEdit Shelter-In-Place Webinar 4: Merging, Clustering, and Integrations…oh...MarcEdit Shelter-In-Place Webinar 4: Merging, Clustering, and Integrations…oh...
MarcEdit Shelter-In-Place Webinar 4: Merging, Clustering, and Integrations…oh...Terry Reese
 
MarcEdit Shelter-in-place Webinar 2.5: Getting Started with MarcEdit Mac
MarcEdit Shelter-in-place Webinar 2.5: Getting Started with MarcEdit MacMarcEdit Shelter-in-place Webinar 2.5: Getting Started with MarcEdit Mac
MarcEdit Shelter-in-place Webinar 2.5: Getting Started with MarcEdit MacTerry Reese
 
Slides from the NASIG 2018 Preconference
Slides from the NASIG 2018 PreconferenceSlides from the NASIG 2018 Preconference
Slides from the NASIG 2018 PreconferenceTerry Reese
 
Making complicated processes simple: a look at how MarcEdit 7 is expanding th...
Making complicated processes simple: a look at how MarcEdit 7 is expanding th...Making complicated processes simple: a look at how MarcEdit 7 is expanding th...
Making complicated processes simple: a look at how MarcEdit 7 is expanding th...Terry Reese
 
Rejoining the Information access landscape
Rejoining the Information access landscapeRejoining the Information access landscape
Rejoining the Information access landscapeTerry Reese
 
Open metadata, open systems…redrawing the library metadata landscape
Open metadata, open systems…redrawing the library metadata landscapeOpen metadata, open systems…redrawing the library metadata landscape
Open metadata, open systems…redrawing the library metadata landscapeTerry Reese
 
Getting Started with Regular Expressions In MarcEdit
Getting Started with Regular Expressions In MarcEditGetting Started with Regular Expressions In MarcEdit
Getting Started with Regular Expressions In MarcEditTerry Reese
 
Fitting MarcEdit into the library software ecosystem
Fitting MarcEdit into the library software ecosystemFitting MarcEdit into the library software ecosystem
Fitting MarcEdit into the library software ecosystemTerry Reese
 
Thinking about Preservation: OSUL Content Manage Workflow
Thinking about Preservation: OSUL Content Manage WorkflowThinking about Preservation: OSUL Content Manage Workflow
Thinking about Preservation: OSUL Content Manage WorkflowTerry Reese
 
The world beyond MARC: let’s focus on asking the right questions
The world beyond MARC: let’s focus on asking the right questionsThe world beyond MARC: let’s focus on asking the right questions
The world beyond MARC: let’s focus on asking the right questionsTerry Reese
 
Reframing Public Housing: Visualization and Data Analytics in History
Reframing Public Housing: Visualization and Data Analytics in History Reframing Public Housing: Visualization and Data Analytics in History
Reframing Public Housing: Visualization and Data Analytics in History Terry Reese
 
#mashcat: Evolving MarcEdit: Leveraging Semantic Data in MarcEdit
#mashcat: Evolving MarcEdit: Leveraging Semantic Data in MarcEdit#mashcat: Evolving MarcEdit: Leveraging Semantic Data in MarcEdit
#mashcat: Evolving MarcEdit: Leveraging Semantic Data in MarcEditTerry Reese
 
Preparing Catalogers for Linked data
Preparing Catalogers for Linked dataPreparing Catalogers for Linked data
Preparing Catalogers for Linked dataTerry Reese
 
Harnessing the Lifecycle: Planning and Implementing a Strategic Digital Coll...
Harnessing the Lifecycle: Planning and Implementing a Strategic Digital Coll...Harnessing the Lifecycle: Planning and Implementing a Strategic Digital Coll...
Harnessing the Lifecycle: Planning and Implementing a Strategic Digital Coll...Terry Reese
 
Practical approaches to entification in library bibliographic data
Practical approaches to entification in library bibliographic dataPractical approaches to entification in library bibliographic data
Practical approaches to entification in library bibliographic dataTerry Reese
 
AALL 2015: Hands on Linked Data Tools for Catalogers: MarcEdit and MARCNext
AALL 2015: Hands on Linked Data Tools for Catalogers: MarcEdit and MARCNextAALL 2015: Hands on Linked Data Tools for Catalogers: MarcEdit and MARCNext
AALL 2015: Hands on Linked Data Tools for Catalogers: MarcEdit and MARCNextTerry Reese
 
Open Repositories 2014 Poster -- Managing Change: An Organizational Outline f...
Open Repositories 2014 Poster -- Managing Change: An Organizational Outline f...Open Repositories 2014 Poster -- Managing Change: An Organizational Outline f...
Open Repositories 2014 Poster -- Managing Change: An Organizational Outline f...Terry Reese
 

More from Terry Reese (20)

MarcEdit Shelter-In-Place Webinar 7: Making Regular Expressions work for you ...
MarcEdit Shelter-In-Place Webinar 7: Making Regular Expressions work for you ...MarcEdit Shelter-In-Place Webinar 7: Making Regular Expressions work for you ...
MarcEdit Shelter-In-Place Webinar 7: Making Regular Expressions work for you ...
 
MarcEdit Shelter-In-Place Webinar 6: Regular Expressions and .NET, A Primer
MarcEdit Shelter-In-Place Webinar 6: Regular Expressions and .NET, A PrimerMarcEdit Shelter-In-Place Webinar 6: Regular Expressions and .NET, A Primer
MarcEdit Shelter-In-Place Webinar 6: Regular Expressions and .NET, A Primer
 
MarcEdit Shelter-In-Place Webinar 5.5: Transliterations in MarcEdit
MarcEdit Shelter-In-Place Webinar 5.5: Transliterations in MarcEditMarcEdit Shelter-In-Place Webinar 5.5: Transliterations in MarcEdit
MarcEdit Shelter-In-Place Webinar 5.5: Transliterations in MarcEdit
 
MarcEdit Shelter-In-Place Webinar 4: Merging, Clustering, and Integrations…oh...
MarcEdit Shelter-In-Place Webinar 4: Merging, Clustering, and Integrations…oh...MarcEdit Shelter-In-Place Webinar 4: Merging, Clustering, and Integrations…oh...
MarcEdit Shelter-In-Place Webinar 4: Merging, Clustering, and Integrations…oh...
 
MarcEdit Shelter-in-place Webinar 2.5: Getting Started with MarcEdit Mac
MarcEdit Shelter-in-place Webinar 2.5: Getting Started with MarcEdit MacMarcEdit Shelter-in-place Webinar 2.5: Getting Started with MarcEdit Mac
MarcEdit Shelter-in-place Webinar 2.5: Getting Started with MarcEdit Mac
 
Slides from the NASIG 2018 Preconference
Slides from the NASIG 2018 PreconferenceSlides from the NASIG 2018 Preconference
Slides from the NASIG 2018 Preconference
 
Making complicated processes simple: a look at how MarcEdit 7 is expanding th...
Making complicated processes simple: a look at how MarcEdit 7 is expanding th...Making complicated processes simple: a look at how MarcEdit 7 is expanding th...
Making complicated processes simple: a look at how MarcEdit 7 is expanding th...
 
Rejoining the Information access landscape
Rejoining the Information access landscapeRejoining the Information access landscape
Rejoining the Information access landscape
 
Open metadata, open systems…redrawing the library metadata landscape
Open metadata, open systems…redrawing the library metadata landscapeOpen metadata, open systems…redrawing the library metadata landscape
Open metadata, open systems…redrawing the library metadata landscape
 
Getting Started with Regular Expressions In MarcEdit
Getting Started with Regular Expressions In MarcEditGetting Started with Regular Expressions In MarcEdit
Getting Started with Regular Expressions In MarcEdit
 
Fitting MarcEdit into the library software ecosystem
Fitting MarcEdit into the library software ecosystemFitting MarcEdit into the library software ecosystem
Fitting MarcEdit into the library software ecosystem
 
Thinking about Preservation: OSUL Content Manage Workflow
Thinking about Preservation: OSUL Content Manage WorkflowThinking about Preservation: OSUL Content Manage Workflow
Thinking about Preservation: OSUL Content Manage Workflow
 
The world beyond MARC: let’s focus on asking the right questions
The world beyond MARC: let’s focus on asking the right questionsThe world beyond MARC: let’s focus on asking the right questions
The world beyond MARC: let’s focus on asking the right questions
 
Reframing Public Housing: Visualization and Data Analytics in History
Reframing Public Housing: Visualization and Data Analytics in History Reframing Public Housing: Visualization and Data Analytics in History
Reframing Public Housing: Visualization and Data Analytics in History
 
#mashcat: Evolving MarcEdit: Leveraging Semantic Data in MarcEdit
#mashcat: Evolving MarcEdit: Leveraging Semantic Data in MarcEdit#mashcat: Evolving MarcEdit: Leveraging Semantic Data in MarcEdit
#mashcat: Evolving MarcEdit: Leveraging Semantic Data in MarcEdit
 
Preparing Catalogers for Linked data
Preparing Catalogers for Linked dataPreparing Catalogers for Linked data
Preparing Catalogers for Linked data
 
Harnessing the Lifecycle: Planning and Implementing a Strategic Digital Coll...
Harnessing the Lifecycle: Planning and Implementing a Strategic Digital Coll...Harnessing the Lifecycle: Planning and Implementing a Strategic Digital Coll...
Harnessing the Lifecycle: Planning and Implementing a Strategic Digital Coll...
 
Practical approaches to entification in library bibliographic data
Practical approaches to entification in library bibliographic dataPractical approaches to entification in library bibliographic data
Practical approaches to entification in library bibliographic data
 
AALL 2015: Hands on Linked Data Tools for Catalogers: MarcEdit and MARCNext
AALL 2015: Hands on Linked Data Tools for Catalogers: MarcEdit and MARCNextAALL 2015: Hands on Linked Data Tools for Catalogers: MarcEdit and MARCNext
AALL 2015: Hands on Linked Data Tools for Catalogers: MarcEdit and MARCNext
 
Open Repositories 2014 Poster -- Managing Change: An Organizational Outline f...
Open Repositories 2014 Poster -- Managing Change: An Organizational Outline f...Open Repositories 2014 Poster -- Managing Change: An Organizational Outline f...
Open Repositories 2014 Poster -- Managing Change: An Organizational Outline f...
 

Recently uploaded

Karra SKD Conference Presentation Revised.pptx
Karra SKD Conference Presentation Revised.pptxKarra SKD Conference Presentation Revised.pptx
Karra SKD Conference Presentation Revised.pptxAshokKarra1
 
Transaction Management in Database Management System
Transaction Management in Database Management SystemTransaction Management in Database Management System
Transaction Management in Database Management SystemChristalin Nelson
 
Procuring digital preservation CAN be quick and painless with our new dynamic...
Procuring digital preservation CAN be quick and painless with our new dynamic...Procuring digital preservation CAN be quick and painless with our new dynamic...
Procuring digital preservation CAN be quick and painless with our new dynamic...Jisc
 
ENGLISH6-Q4-W3.pptxqurter our high choom
ENGLISH6-Q4-W3.pptxqurter our high choomENGLISH6-Q4-W3.pptxqurter our high choom
ENGLISH6-Q4-W3.pptxqurter our high choomnelietumpap1
 
Like-prefer-love -hate+verb+ing & silent letters & citizenship text.pdf
Like-prefer-love -hate+verb+ing & silent letters & citizenship text.pdfLike-prefer-love -hate+verb+ing & silent letters & citizenship text.pdf
Like-prefer-love -hate+verb+ing & silent letters & citizenship text.pdfMr Bounab Samir
 
Barangay Council for the Protection of Children (BCPC) Orientation.pptx
Barangay Council for the Protection of Children (BCPC) Orientation.pptxBarangay Council for the Protection of Children (BCPC) Orientation.pptx
Barangay Council for the Protection of Children (BCPC) Orientation.pptxCarlos105
 
GRADE 4 - SUMMATIVE TEST QUARTER 4 ALL SUBJECTS
GRADE 4 - SUMMATIVE TEST QUARTER 4 ALL SUBJECTSGRADE 4 - SUMMATIVE TEST QUARTER 4 ALL SUBJECTS
GRADE 4 - SUMMATIVE TEST QUARTER 4 ALL SUBJECTSJoshuaGantuangco2
 
FILIPINO PSYCHology sikolohiyang pilipino
FILIPINO PSYCHology sikolohiyang pilipinoFILIPINO PSYCHology sikolohiyang pilipino
FILIPINO PSYCHology sikolohiyang pilipinojohnmickonozaleda
 
ANG SEKTOR NG agrikultura.pptx QUARTER 4
ANG SEKTOR NG agrikultura.pptx QUARTER 4ANG SEKTOR NG agrikultura.pptx QUARTER 4
ANG SEKTOR NG agrikultura.pptx QUARTER 4MiaBumagat1
 
MULTIDISCIPLINRY NATURE OF THE ENVIRONMENTAL STUDIES.pptx
MULTIDISCIPLINRY NATURE OF THE ENVIRONMENTAL STUDIES.pptxMULTIDISCIPLINRY NATURE OF THE ENVIRONMENTAL STUDIES.pptx
MULTIDISCIPLINRY NATURE OF THE ENVIRONMENTAL STUDIES.pptxAnupkumar Sharma
 
Inclusivity Essentials_ Creating Accessible Websites for Nonprofits .pdf
Inclusivity Essentials_ Creating Accessible Websites for Nonprofits .pdfInclusivity Essentials_ Creating Accessible Websites for Nonprofits .pdf
Inclusivity Essentials_ Creating Accessible Websites for Nonprofits .pdfTechSoup
 
AMERICAN LANGUAGE HUB_Level2_Student'sBook_Answerkey.pdf
AMERICAN LANGUAGE HUB_Level2_Student'sBook_Answerkey.pdfAMERICAN LANGUAGE HUB_Level2_Student'sBook_Answerkey.pdf
AMERICAN LANGUAGE HUB_Level2_Student'sBook_Answerkey.pdfphamnguyenenglishnb
 
Incoming and Outgoing Shipments in 3 STEPS Using Odoo 17
Incoming and Outgoing Shipments in 3 STEPS Using Odoo 17Incoming and Outgoing Shipments in 3 STEPS Using Odoo 17
Incoming and Outgoing Shipments in 3 STEPS Using Odoo 17Celine George
 
Global Lehigh Strategic Initiatives (without descriptions)
Global Lehigh Strategic Initiatives (without descriptions)Global Lehigh Strategic Initiatives (without descriptions)
Global Lehigh Strategic Initiatives (without descriptions)cama23
 
call girls in Kamla Market (DELHI) 🔝 >༒9953330565🔝 genuine Escort Service 🔝✔️✔️
call girls in Kamla Market (DELHI) 🔝 >༒9953330565🔝 genuine Escort Service 🔝✔️✔️call girls in Kamla Market (DELHI) 🔝 >༒9953330565🔝 genuine Escort Service 🔝✔️✔️
call girls in Kamla Market (DELHI) 🔝 >༒9953330565🔝 genuine Escort Service 🔝✔️✔️9953056974 Low Rate Call Girls In Saket, Delhi NCR
 
Choosing the Right CBSE School A Comprehensive Guide for Parents
Choosing the Right CBSE School A Comprehensive Guide for ParentsChoosing the Right CBSE School A Comprehensive Guide for Parents
Choosing the Right CBSE School A Comprehensive Guide for Parentsnavabharathschool99
 
ISYU TUNGKOL SA SEKSWLADIDA (ISSUE ABOUT SEXUALITY
ISYU TUNGKOL SA SEKSWLADIDA (ISSUE ABOUT SEXUALITYISYU TUNGKOL SA SEKSWLADIDA (ISSUE ABOUT SEXUALITY
ISYU TUNGKOL SA SEKSWLADIDA (ISSUE ABOUT SEXUALITYKayeClaireEstoconing
 

Recently uploaded (20)

Karra SKD Conference Presentation Revised.pptx
Karra SKD Conference Presentation Revised.pptxKarra SKD Conference Presentation Revised.pptx
Karra SKD Conference Presentation Revised.pptx
 
Transaction Management in Database Management System
Transaction Management in Database Management SystemTransaction Management in Database Management System
Transaction Management in Database Management System
 
Procuring digital preservation CAN be quick and painless with our new dynamic...
Procuring digital preservation CAN be quick and painless with our new dynamic...Procuring digital preservation CAN be quick and painless with our new dynamic...
Procuring digital preservation CAN be quick and painless with our new dynamic...
 
ENGLISH6-Q4-W3.pptxqurter our high choom
ENGLISH6-Q4-W3.pptxqurter our high choomENGLISH6-Q4-W3.pptxqurter our high choom
ENGLISH6-Q4-W3.pptxqurter our high choom
 
Like-prefer-love -hate+verb+ing & silent letters & citizenship text.pdf
Like-prefer-love -hate+verb+ing & silent letters & citizenship text.pdfLike-prefer-love -hate+verb+ing & silent letters & citizenship text.pdf
Like-prefer-love -hate+verb+ing & silent letters & citizenship text.pdf
 
Barangay Council for the Protection of Children (BCPC) Orientation.pptx
Barangay Council for the Protection of Children (BCPC) Orientation.pptxBarangay Council for the Protection of Children (BCPC) Orientation.pptx
Barangay Council for the Protection of Children (BCPC) Orientation.pptx
 
GRADE 4 - SUMMATIVE TEST QUARTER 4 ALL SUBJECTS
GRADE 4 - SUMMATIVE TEST QUARTER 4 ALL SUBJECTSGRADE 4 - SUMMATIVE TEST QUARTER 4 ALL SUBJECTS
GRADE 4 - SUMMATIVE TEST QUARTER 4 ALL SUBJECTS
 
FILIPINO PSYCHology sikolohiyang pilipino
FILIPINO PSYCHology sikolohiyang pilipinoFILIPINO PSYCHology sikolohiyang pilipino
FILIPINO PSYCHology sikolohiyang pilipino
 
ANG SEKTOR NG agrikultura.pptx QUARTER 4
ANG SEKTOR NG agrikultura.pptx QUARTER 4ANG SEKTOR NG agrikultura.pptx QUARTER 4
ANG SEKTOR NG agrikultura.pptx QUARTER 4
 
Raw materials used in Herbal Cosmetics.pptx
Raw materials used in Herbal Cosmetics.pptxRaw materials used in Herbal Cosmetics.pptx
Raw materials used in Herbal Cosmetics.pptx
 
MULTIDISCIPLINRY NATURE OF THE ENVIRONMENTAL STUDIES.pptx
MULTIDISCIPLINRY NATURE OF THE ENVIRONMENTAL STUDIES.pptxMULTIDISCIPLINRY NATURE OF THE ENVIRONMENTAL STUDIES.pptx
MULTIDISCIPLINRY NATURE OF THE ENVIRONMENTAL STUDIES.pptx
 
Inclusivity Essentials_ Creating Accessible Websites for Nonprofits .pdf
Inclusivity Essentials_ Creating Accessible Websites for Nonprofits .pdfInclusivity Essentials_ Creating Accessible Websites for Nonprofits .pdf
Inclusivity Essentials_ Creating Accessible Websites for Nonprofits .pdf
 
AMERICAN LANGUAGE HUB_Level2_Student'sBook_Answerkey.pdf
AMERICAN LANGUAGE HUB_Level2_Student'sBook_Answerkey.pdfAMERICAN LANGUAGE HUB_Level2_Student'sBook_Answerkey.pdf
AMERICAN LANGUAGE HUB_Level2_Student'sBook_Answerkey.pdf
 
YOUVE_GOT_EMAIL_PRELIMS_EL_DORADO_2024.pptx
YOUVE_GOT_EMAIL_PRELIMS_EL_DORADO_2024.pptxYOUVE_GOT_EMAIL_PRELIMS_EL_DORADO_2024.pptx
YOUVE_GOT_EMAIL_PRELIMS_EL_DORADO_2024.pptx
 
Incoming and Outgoing Shipments in 3 STEPS Using Odoo 17
Incoming and Outgoing Shipments in 3 STEPS Using Odoo 17Incoming and Outgoing Shipments in 3 STEPS Using Odoo 17
Incoming and Outgoing Shipments in 3 STEPS Using Odoo 17
 
YOUVE GOT EMAIL_FINALS_EL_DORADO_2024.pptx
YOUVE GOT EMAIL_FINALS_EL_DORADO_2024.pptxYOUVE GOT EMAIL_FINALS_EL_DORADO_2024.pptx
YOUVE GOT EMAIL_FINALS_EL_DORADO_2024.pptx
 
Global Lehigh Strategic Initiatives (without descriptions)
Global Lehigh Strategic Initiatives (without descriptions)Global Lehigh Strategic Initiatives (without descriptions)
Global Lehigh Strategic Initiatives (without descriptions)
 
call girls in Kamla Market (DELHI) 🔝 >༒9953330565🔝 genuine Escort Service 🔝✔️✔️
call girls in Kamla Market (DELHI) 🔝 >༒9953330565🔝 genuine Escort Service 🔝✔️✔️call girls in Kamla Market (DELHI) 🔝 >༒9953330565🔝 genuine Escort Service 🔝✔️✔️
call girls in Kamla Market (DELHI) 🔝 >༒9953330565🔝 genuine Escort Service 🔝✔️✔️
 
Choosing the Right CBSE School A Comprehensive Guide for Parents
Choosing the Right CBSE School A Comprehensive Guide for ParentsChoosing the Right CBSE School A Comprehensive Guide for Parents
Choosing the Right CBSE School A Comprehensive Guide for Parents
 
ISYU TUNGKOL SA SEKSWLADIDA (ISSUE ABOUT SEXUALITY
ISYU TUNGKOL SA SEKSWLADIDA (ISSUE ABOUT SEXUALITYISYU TUNGKOL SA SEKSWLADIDA (ISSUE ABOUT SEXUALITY
ISYU TUNGKOL SA SEKSWLADIDA (ISSUE ABOUT SEXUALITY
 

Working with the MarcEditor

  • 2.
  • 3. What can I use MarcEdit for? A few things MarcEdit can help users: 1. Automate processing of vendor MARC records for e-records 2. Facilitate large data clean up projects, like updating subject or name authorities 3. Converting AACR2 data to Hybrid-RDA records (true RDA conversion isn’t just about field changes, but requires a reassessment of the content) 4. Convert data from non-MARC formats like Dublin Core, MODS, EAD, MARCXML, or other XML or JSON formats to MARC or from MARC to various non-MARC formats 5. Reconcile MARC data to utilize Linked data concepts 6. Validate records 7. Join or Split large data sets 8. Manage Character encodings and Unicode Normalizations 9. Integration with OCLC and ILS systems 10. Merging data between data sets or data files 11. Retrieve data from remote sources through OAI, Z39.50, SRU, Atom Pub, etc.
  • 5. Editing in MarcEdit Workflow process looks like… 1. Validate Records for initial errors (or targeted review) 2. “Break MARC data to mnemonic” 3. Open “broken” records into the MarcEditor 4. Perform Global Edits to clean your data 5. Save your changes 6. “Compile” your records back to MARC for addition into your ILS Create your own Validation fields MarcEdit can open records directly into the Editor Automate your changes Ingest records directly through integrations with supported ILS systems like Koha, Alma, Evergreen, and OCLC.
  • 7. How do I get started? 1. MarcEdit 101 Webinar Series: marcedit.reeset.net/marcedit-101-workshop 2. Knowledge-base Items: marcedit.reeset.net/archives/category/knowledge_base 3. Tutorials: marcedit.reeset.net/tutorials 4. Sample Lesson Plan (In development): github.com/reeset/marcedit_sample_lesson_plan
  • 8. How do I get help? MarcEdit Listserv URL: http://listserv.gmu.edu/cgi-bin/wa?A0=marcedit-l The MarcEdit Listserv is hosted by George Mason University and provides users an opportunity to send questions to the MarcEdit user community. What’s more, the list includes a searchable archive. Contact the Author: URL: reeset@gmail.com I’m always open to people contacting me and asking questions. Built-in Help
  • 10. Addressing Unicode Normalization Fragmentation How Does MarcEdit 7 Address this? Through the Preferences
  • 11. Edit Shortcuts Edit Shortcuts tend to have the following characteristics: ◦ Could be MARC21 Specific ◦ Represent items that could be written as regular expressions, but expressions that are difficult to write ◦ Require mathematical or data conversions ◦ Are more one-off functions than “global tools” ◦ Often can be added to tasks.
  • 12.
  • 13. Editing MARC – Find/Replace Works like a normal Find/Replace in most Textpad utilities. Unlike most Textpads, Replace supports UTF-8 (when working with UTF-8 files) and regular expressions.
  • 15. Editing MARC – Find All Find all function was designed for use with the Paging mode Allows users to find any text across all pages Generates a jump list that can be used to find individual records for edit
  • 16. Miscellaneous Tools Generate Cutters (sanborn and other) Generate Record from URL (one a website, one from LC)
  • 17. Editing MARC – Global Add/Delete Field Globally add fields to all MARC records ◦ Allows users to set insertion position. Globally delete fields ◦ Allows global delete ◦ Allows conditional delete Supports Regular Expressions
  • 18. Editing MARC – Modifying subfield data Allows for the modification of variable MARC field subfield data (MARC fields >10) Allows for the modification of control field data by position or range of positions Allows users to prepend and append data to subfields. Allows users to change subfield tagging.
  • 19. Editing MARC – Modifying subfield data Allows users to insert new subfields and define subfield placement. Allows users to move field data from one field to another. Supports: • UTF-8 with UTF-8 files • Regular Expressions • Adding new subfields.
  • 20. Editing MARC – Modifying subfield data Specify insertion position: https://marcedit.reeset.net/set- subfield-insert-position
  • 21. Editing MARC – Swapping Fields Swap parts of MARC Fields or entire MARC fields ◦ Define field, indicator and subfields to move. ◦ Can move field data and delete the original field or clone the field data and move the clone to the new location. ◦ Can add data to an existing field.
  • 22. Build New Field Tool Build New Field Tool This method works well when needing to build complex proxy statements
  • 23. Build New Field Modifier functions ◦ Find ◦ replace ◦ trim ◦ trimstart ◦ trimend ◦ substring ◦ Regex All functions can be stacked except the find function. If you use this function, it must be the first in the chain. Example: =856 $a{090.find(“G42”).trim()}$zConnect to this resource online. Example: =901 $a{LDR.substring(6,1)}$b{904$a}$mDate: {260$c.trim(“ .”)}
  • 24. Character Conversions within the MarcEditor MARCEDITOR ALLOWS USERS TO CONVERT CHARACTER DATA BETWEEN DIFFER ENT CHARACTERSETS.
  • 25. Fixing Boo-boos MarcEdit’s Special Undo ◦ Allows you to step back one global change.
  • 26. Sorting Fields MarcEdit provides multiple sorting types: ◦ Control Number ◦ Sorts record position within the file ◦ Title ◦ Sorts record position within the file ◦ Author ◦ Sorts record position within the file ◦ Call Number ◦ Sorts record position within the file ◦ 0xx Fields ◦ Sorts the 0xx fields within individual records (does *not* change record position within a file) ◦ All Fields ◦ Sorts all fields within individual records (does *not* change record position within a file) ◦ Custom Sort ◦ Sorts all defined fields within individual records (does *not* change record position within a file)
  • 27. MARC Data Reports MarcEdit includes a number of validation/information reports: § Field Count Reports § Including information related to indicator/subfield usage § Material Type Reports § Generate Reports and pull together records for each material type § Validate ISBN/ISSN Reports § Mathematically validates check digit § Validate Headings *NEW* § Validates all access points against LCSH and LC NAF
  • 28. Field Counts Field Count ◦ Provides a quick count of fields ◦ Report of subfields used within a particular field ◦ Detailed reports of all fields/subfields used within a fileset.
  • 29. Material Type Report Material Type Report ◦ Reports number of records by material type ◦ Breaks down material type by sub- types ◦ Utilizes the Leader, 008 and GMD to determine format types
  • 31. In-Line Validation MarcValidator-lite ◦ Can access MarcValidator for quick validation of data elements found in the file set ◦ Validation can use any defined rules set.
  • 32. Change logging MarcEdit provides the ability to log changes made during global edits. Logging isn’t enabled by default, and is turned on via the Preferences Once enabled, logs can be viewed, managed, and enhanced.