This shows you the differences between two versions of the page.
— |
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|}} | ||