User Tools

Site Tools


open_refine_tips_and_tricks

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

open_refine_tips_and_tricks [2025/03/12 17:02] (current)
jeremy created
Line 1: Line 1:
 +[[https://​openrefine.org/​|Open Refine]] is an open source tool that allows you to clean up spreadsheets in preparation for conversion into EAD, or just general cleanup. ​ There is an [[https://​openrefine.org/​docs|extensive user manual]], but we will be collecting commands here that are most useful for our use cases.
 +
 +===== Insert text at beginning or end of string =====
 +
 +Select column you wish to insert text in then select **Edit cells--->​Transform...**
 +
 +{{:​screenshot_2025-03-12_at_12.55.07_pm.png?​400|}}
 +
 +Beginning of string: //​("​text to insert"​)value+//​
 +
 +{{:​screenshot_2025-03-12_at_12.56.21_pm.png?​400|}}
 +
 +End of string: //value+ ("text to insert"​)//​
 +
 +{{::​screenshot_2025-03-12_at_12.55.57_pm.png?​400|}}
  
open_refine_tips_and_tricks.txt ยท Last modified: 2025/03/12 17:02 by jeremy