export to csv - Convert Link to 'a href' link in multi data Csv file in Open refine

Question

I am a beginner in OpenRefine and GREL and I want to transform the links of my CSV file (which contains 500 records) into clickable HTML links with a href = "".

For example: http://www.my-link.com becomes <a href="http://www.my-link.com"> http://www.my-link.com </a>

Answer 1

You can concatenate in GREL by simply using the + sign. For your example the expression is: '<a href="'+value+'">'+value+'</a>'

You need to put any hard coded string between single quote ' so OpenRefine is not confused with the actual double-quote " of the HTML.