Find and replace — Trusty CSV User Guide

Search the User Guide

Windows · Linux · Mac

Ctrl + F ⌘ F opens the search bar at the top of the file, with the selected text already in it. Matches are highlighted as you type. Enter goes to the next, Shift + Enter ⇧ Enter to the previous (also F3 and Shift + F3 ⇧ F3, or the next and previous buttons), and all selects every match, with a cursor on each. Esc closes the bar.

In the column

The search keeps to the column of the cursor: the option in column “city” is ticked when the bar opens, and says which column it is. Matches have to be inside a value of that column, and the header row is left out. Moving to the next match never takes you to another column; click in another column and the search goes there.

Untick it to search the whole file. It stays unticked, the next times you open the bar, until you reload the page; then it starts ticked again.

Options

Replace

Ctrl + H ⌘ H opens the bar with the cursor in the replace field. replace changes the current match and goes to the next one; replace all changes every match, in the column or in the file, and is one step of Ctrl + Z ⌘ Z.

To change many values at once there are faster ways, too: select them with Ctrl + Shift + L ⇧ ⌘ L and type (see Multiple cursors), or use the Cells menu to trim spaces, change capitals or fill empty cells.