Normalizing URLs in OpenRefine
Sometimes you have data like www.example.com or http://www.example.com.
Here is a GREL expression to prefix them with HTTP, using Edit cells > Transform…
if(isNonBlank(value), 'http://'+replace(value, /^https?:\/\//, ''), null)Written by Oncle Tom
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Data
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#