...
Use the normalize ISSNs macro
- Open the Normalize ISSNs macro.
- Copy the code found on the page beginning with the first open bracket and ending with the last close bracket.
- In OpenRefine, switch to the Undo/Redo tab.
- Click "Apply" and copy the code from the wiki page into the text box.
- Click "Perform operations."Right-click any cell and select "Apply Macro"
- Search for the Normalize ISSNs and eISSNs macro
- Click OK to run the macro
- Change back to the Errors tab and check to see if this error is still present. If this has not solved the problem, try the solution below.
Rename a column with a macro
Right-click any cell and select Apply Macro
Search for the name of the package and/or provider to locate the correct macro, or search for the KBART (generic) macro.
Click Ok to run the macro
Facet your data
- Open the quick resolution menu by clicking on the wrench icon in the upper right corner of the error message."Quick Resolution."
- Choose "Create facet."
- OpenRefine will create a facet of all the ISSNs that do not correspond to the correct format. Choose the "Invalid" facet.
- You will now see a filtered view of your project that shows only the incorrectly formatted ISSNs.
- If there are only a handful, fix them manually.
- If there are too many to correct one-by-one, contact the editor for help with the conversion process.
...