646
edits
Resources for using OpenRefine: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
| Line 16: | Line 16: | ||
Download OpenRefine from https://openrefine.org. | Download OpenRefine from https://openrefine.org. | ||
=Handy expressions= | |||
value+"yourtexthere" | |||
value.toDate().toString('YYYY-MM-dd') | |||
value.replace(/\s+/,' ') | |||
cells["'''COLUMN-1'''"].value[0] == cells["'''COLUMN-2'''"].value[0] | |||
cell.cross("'''TABLE-2'''", "'''COLUMN-TO-MATCH-ON'''")[0].cells["'''COLUMN-TO-GET-VALUE-FROM'''"].value | |||
forEach(row.record.cells[''''COLUMN''''].value,v,v).uniques().length() | |||
forEach(value.parseJson().results[0].'''TARGET''',x,[x.types[0], x.'''TARGET'''].join("::")).join("|") | |||
https://maps.googleapis.com/maps/api/geocode/json?latlng="+value+"&key='''KEY''' | |||
=Join the community= | =Join the community= | ||