HomeSpreadsheet WindowHow to edit spreadsheet itemsSave CSV file
  CSVEditor 2 > Spreadsheet Window Index

Find & Replace

You can use Edit > Find to search the content in all data fields. When you choose this menu function, a Search sheet is shown.

Find

Finds the Search string and marks all relevant rows and column titles.

Replace

Finds and replaces the first occurrence of the Search string by the Replace string.

Replace All

Finds and replaces all occurrences of the Search string by the Replace string.

Select All

Selects all rows where the Search string has been found.

You can either search all rows in all columns, or specify a column to search in. You may also use a case-insensitive search by checking the relevant checkbox.

For Regular Expressions, the Find & Replace mechanism uses the ICU Library implemented in Mac OS X. Here you find an overview of the Regular Expressions:
http://userguide.icu-project.org/strings/regexp

The other Edit menu functions (Find Next, Replace, Replace & Find Next) can be used as usual, after the first Find operation has been successful.


HomeSpreadsheet WindowHow to edit spreadsheet itemsSave CSV file