Text replacement items
Text replacement has the following options:
REPLACE - This swaps text for the replacement text. The text has to match exactly. For example, so if the text retrieved from the database was 'INSTOCK', you could choose to replace this with 'This item is currently in stock'. You can add as many different replacements as you like. However, if the text received from the database is 'instock' then you would need to take the tick out of the 'Match case' check box so that Repeat Signage sees 'INSTOCK', 'instock', etc, all as a match. The 'Trim spaces first' would take a database value of ' INSTOCK' (which has some spaces before the INSTOCK') so that it still matches.
FIND AND REPLACE - This will find and replace the text you enter. For example, if the text collected from the database is:
Please visit www.repeatsoftware.com/Product1.htm
but you have changed the website, you could do a replace on 'www.repeatsoftware.com' and replace with 'www.newwebsite.com', which would give.
Please visit www.newwebsite.com/Product1.htm
Number/Currency/Percent replacement items
EQUALS - If the number from the database matches exactly the number you type, then it is replaced with the text. For example, you would could replace a stock quantity field value 0 with 'Out of stock'.
NOT EQUAL TO - If the number collected from the database is not equal to a value. An example would be if a stock quality is NOT 0, then display 'In stock'.
GREATER THAN - Replace the number from the database with your replacement text if the number is higher than the one you enter.
GREATER THAN OR EQUAL TO - Replace the number from the database with your replacement text if the number is higher or equal to than the one you enter.
GREATER THAN - Replace the number from the database with your replacement text if the number is higher than the one you enter.
GREATER THAN OR EQUAL TO - Replace the number from the database with your replacement text if the number is higher or equal to than the one you enter.
LESS THAN - Replace the number from the database with your replacement text if the number is lower than the one you enter.
LESS THAN OR EQUAL TO - Replace the number from the database with your replacement text if the number is lower or equal to than the one you enter.
Additional options such as prefixes and suffixes
There are applied after any replacements have been made. Use the 'Additional' tab to add these if needed.