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, CSPACE)} 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.
DISPLAY Commands
ACCORDION
AJAX_EMBED
BASIC_DISP
BLINK
CALENDAR
COMMA
COMMENT
DQUOTE
EDITABLE
FAVICON
FIRST_LINE
FORMAT_DATE
GLINK
GLINK_OFF
GLINK_ON
HTML_SPECIAL_CHARS
HTML_TO_TEXT
IMPORT_FORM
LCASE
MAIN_PAGE
NALB
NOTIFY
OBJ_COLOR
PAGE_JS
PAGE_JS2
PAGE_TITLE
PANEL
PANEL_CLOSED
PANEL_OPEN
PILLS
PLURAL
PRINT_BUTTON
QR_CODE
REGISTER
REG_REP
RENDER_TREE
RETURN_TIDY
SEQN
SET_PAGE_TITLE
SIDEBAR_LEFT/RIGHT
SLIDES
SYMBOL
TEL_LINK
TRACKING_IMAGE
TRIM
WRAP