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|}} | ||