Search & Replace

The song inventory & replace mechanism provides a quick way to mass change field values in the Song Inventory database and to apply or change
color coding of song records. It is also useful for populating blank fields. Supported fields are Key, Vocals, Tempo, Album and Artist. The Title, Ratings/Comments and Duration fields are not included as they tend to be unique in nature and therefore not suitable for search & replace. Access this tool by selecting Edit-->Search & Replace from the main menu on the Song Inventory notetab or by right clicking within the Song Inventory table itself.


Radio buttons

Click the 'Field text' or 'Song color' radio button to specify the appropriate search / replace mode.


Field Text - Use this selection to change field text in some or all records in the song inventory. The field to be inspected, the text to be changed and the replacement text are defined by the placing criteria in the [Field name], [Find] and [Replace with:] fields.









Song Color - The procedure is the same as what is used in 'Field text' mode except the song color is being replaced instead of song inventory field text.













Replacing field text - How it works

As an example, let's assume that vocalist Julie is leaving and you hire vocalist Melanie to sing most of Julie's songs. If you want to keep the song inventory up to date, you will need to change all song inventory occurrences of Julie, to Melanie.

1. Click the Field text radio button


2.
Select the LIST button in the <Field name> object and select 'Vocals' from the resulting menu. This field is read-only and is populated only by selecting the LIST button.


3.
In the <Find> field object , click the LIST button and select "Julie" from the resulting menu. This field is read-only and is populated by selecting the LIST button, as well.


4.
Move to the <Replace with> field and type in "Melanie". Alternatively, you can click that field's LIST button and select from the menu if an existing member is taking over the vocals.


5.
If you want to examine every change before it is posted, CHECK the
Confirm before replace checkbox. This will provide a Yes/No/Cancel dialog for every occurrence of Julie, thereby enabling you to cherry-pick the songs that you want to change.


6.
When you are satisfied with your settings, click the Execute button to initiate the procedure.


Replacing song color - How it works

As an example, let's say that you want songs with "Slow" in the tempo field to display as blue but you would prefer not to edit the songs record individually.

1. Select the 'Song color' radio button


2.
Click the LIST button in the <Field name> object and select 'Tempo' from the resulting menu. This field is read-only and is populated only by selecting the LIST button.


3. In the <Find> field object , click the LIST button and select "Slow" from the resulting menu. This field is read-only and is populated by selecting the LIST button, as well.


3.
Click LIST button next to the Song color field and select Blue from the menu.


4.
If you want to examine every change before it is posted, CHECK the
Confirm before replace checkbox. This will provide a Yes/No/Cancel dialog for every occurrence of "slow", enabling you to cherry-pick the songs that you want to change.

5. When you are satisfied with your settings, click the Execute button to initiate the procedure.

Tips:

Populating blank fields

You can use the Search & Replace dialog to populate blank fields. For example, you can do mass entry of song keys assuming they are blank to start with. First, select "Key" using the <Field name> LIST button. Leave the <Find> field blank, and enter a song key in the <Replace with> field. Be sure to CHECK <Confirm before replace> so you can examine each song and choose whether to use the current key for that song. Repeat with other song keys.

Reverse changes

- This button is only visible when the 'Field text' radio button is selected. Clicking this button will swap the values of the <Find> and <Replace with> fields. This function may be useful if you have made a mistake and wish to reverse the changes.