Search and Replace

Ribbon TABLE - Group Edit

SearchAndReplace2_32x32This function can be used to search database entries and replace them with other values.

 

Chose the table and column to search for.

Search for: Enter the expression to be searched for or click on the [...] button to list all the entries in the column.

Replace with: Enter the expression to replace the search expression. If you only want to search, this field can be left blank.

SuchenErsetzen_Dialog

 

Suchoptionen

contained

The expression is searched at any position.

from left

The expression is searched at the beginning.

from right

The expression is searched at the end.

start from X

The expression is searched from position X to the left or right.

exact

The expression is exactly the same (equal search).

case-sensitive

Case is considered.

replace multiple matches

If an expression occurs several times in a column, it can also be replaced several times. Otherwise, only the first hit will be replaced.

Show result after dialog closing

Opens the search result as a table.

 

Schaltflächen

Search

Search for the expression in the input field Search for.

By selecting a value in the search results list, it is transferred to the search input field. The search value will be reset to the original search value after replacement and will be executed again (the list will become shorter per replacement).

Replace

Search for the expression in the input field Search for and replace it with the new expression in the input field Replace with.

Save

Changes are saved directly.

Rollback

Changes that have not been saved will be undone.

Close

Ends the function without saving.