Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.3k views
in Technique[技术] by (71.8m points)

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

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>


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...