7.1
2013-09-23

REPLACE

Syntax

REPLACE(Text, Text to find, Replace with text)

Description

Looks for<Text to find> in <Text> and replaces every occurrence with <Replace with text>.

Example

REPLACE("PrintShop Mail", " ", "") => PrintShopMail
Parameter description

Text

Any text expression or data field containing a text.

Text to find

Any text expression or data field containing a text.

Replace with text

String to replace occurrences of <Find string>. Any text expression or data field containing a text.