Quick Fix Transformations
- Former user (Deleted)
- Eric Hanson (Unlicensed)
- Kristen Wilson
Owned by Former user (Deleted)
This page contains a number of 'quick fix' transformations designed to help with commonly seen issues in journal lists. Generally to apply these, you will need to use the dropdown at the top of a relevant column in Refine, choose 'Edit cells' -> 'Transform...' then paste the relevant transformation code into the 'Expression' box and click 'OK'
| Issue | Transformation | Notes |
|---|---|---|
| ISSNs not hypenated (e.g. 18762859 rather than 1876-2859) | splitByLengths(value,4,4).join("-") | |
| ISSNs user lowercase x (e.g 1146-609x rather than 1146-609X) | replace(value,"x","X") | |
| Invalid end dates formatted like 2012 | inc(inc(toDate(value),1,"year"),-1,"day") | (results in [date 2012-12-31T00:00:00Z]) |
| Invalid end dates fomatted like 2012-12 | inc(inc(toDate(value),1,"month"),-1,"day") | (results in [date 2012-12-31T00:00:00Z]) |
Operated as a Community Resource by the Open Library Foundation