Organizer Advantage, Search and Replace

Organizer Advantage is powerful yet easy to use database manager for Windows.
Advantage Designer lets you modify our solutions or easily create new databases.
Take control of your data with our simple or buinsess database software solutions.

| Organizer Advantage HowTo/Help | Designer HowTo/Help |

Advantage Help > Search, Replace > Search, Replace

Search and Replace

The replace is listed in the replace toolbar section. The Replace function helps you to replace the entire or the part of the field's content with a new value. Use this function with caution. It will check all currently displayed records. Make sure you selected the desired set of records using the Advanced Search function. The replace process cannot be undone. You can create a backup file, so that you can restore your records in the case of an error.

This function is useful for users who want to make global changes on the selected field in the entire database. How much time does it take to change one field in a small database of 1000 records? The replace function needs only several seconds to accomplish this task. If the replace process is done manually, it can take thousands of times longer, and there is also a chance of introducing some typing errors.

advantage, search replace, replace toolbar

Entire Field Content

Replace Entire Field Contents: select this mode if you would like to replace the entire content of the selected field with the Replace With string. For example, you entered temporary data into USERFIELD data field. Now you want to clean the contents of this field. Use replace with empty string.

advantage, search replace, replace entire field

Substring Only

Substring Only: select this mode if you would like to replace a part of the selected field. It will search for the text specified in the Substring To Replace edit box. Each found text will be replaced with a new value.

advantage, search replace, replace substring

Auto-Increment, Auto-Decrement

Auto-Increment: select this mode if you would like to number your records. Enter the initial value in the Start From edit box. The number that will replace the content of the selected field is incremented by one and starts from the value entered in the Start From edit box.

advantage, search replace, replace auto increment

Insert In Front, Append To End

Insert In Front: select this mode if you would like to insert the text in front of the selected field content. Insert If Found option: only records with Insert If Found text will be modified. If Insert If Found edit box is empty, all currently displayed records will be modified.

advantage, search replace, replace insert in front

Remove File Path

Remove File Path: it can be useful for image, attachment, URL address data fields (for example, when the graphic files are moved to a different directory).

advantage, search replace, replace remove path

One Field With Another

Replace One Field With Another Field : select this mode if you want to replace the content of one field with the content of another field. You can replace a Numeric field with a Text field (assuming the text field contains only numbers).

Create Bar Codes

You can create book identification numbers, tag numbers, document numbers that will be represented by text strings with the same length.

Manual creation of the bar code entries for many records could be time consuming. To speed up this process you can use Replace / Create Bar Codes functions.

Define barcode options:
Start From: enter 1 in the Start From box (or enter your start number).
Scope: select First Record in the Start Replacing From section.
Text Prefix: enter Text Prefix(optional).
Barcode Length: enter the maximum length of your barcode (all barcodes should have the same length, example: 001001, 001002,..,009999 length is 6), (DOC-ID-00001, DOC-ID-00002, ..., length is 12)

advantage, search replace, replace create bar codes print labels

First Letter To Upper Case, All Letters To Upper Case, All Letters To Lower Case

All Letters To UPPER CASE: select this mode if you would like to replace all letters of the selected field to upper case.

advantage, search replace, replace replace all letters

New help topics:
Power Replace
Execute SQL Statements
Advantage, database support
Advantage, quick assist

Organizer Advantage, Simple Database Solutions

Organizer Advantage, Business Database Solutions

Organizer Advantage Free Service

Organizer Advantage Support

Database Blog:
Compare Windows over Cloud App
Custom Wine Inventory Database

Organizer Advantage is powerful yet easy to use database manager for Windows. Advantage Designer lets you modify our solutions or easily create new databases. Take control of your data with our simple or buinsess database software solutions.