ULTIMATE DATABASE
HIGH QUALITY BESPOKE SOFTWARE DEVELOPMENT TOOL
Feature Rich
Rapid Application Development
Helping you or your customers
Manage their Business

All Commands All String
Commands

REPLACE

Replaces all occurrences of the search string with the replacement string

You can use {REPLACE({OBJ_DATA(0, address)}, CRLF, {COMMA})} to turn the text in a plain text address to a single line.

This command can have an {END_REPLACE} command.

In this case, the string in-between will replace the first parameter and the format will be {REPLACE} string {{END_REPLACE(parameters 2 onwards)}

This is particularly useful if the string is particularly long or contains commas.

Number Name Default Type Description
1 string String The string to search (Haystack)
3 replace String The string to replace the needle with.
Example Example
AXC
Text Example
This_is_a_simple_sentence,_so_here's_hoping_it_doesn't_get_any_longer!!
to add a Comment.