REPLACE Function
The REPLACE function is a versatile text processing tool, primarily used to manage special characters or patterns within rich text in string properties. However, it can be applied in a variety of other scenarios, making it a powerful tool for string manipulation.
Parameters
String or Property Value: The text or property value in which replacements are to be made.
Search RegEx: The regular expression (RegEx) used to identify the text pattern or characters you want to replace.
Substitution: The text or characters that will replace the identified pattern.
Example Usage:
=REPLACE(GetProperty("code_of_another_property"); "[characters_to_replace_with_regex]"; "substitution")
Description: This example demonstrates replacing specific characters in the code_of_another_property property. The characters to be replaced are identified using a regular expression, and the substitution text will replace the matched pattern.
Example Expression:
=REPLACE(GetProperty("string_multi"); "<[^>]+>"; "")
Description: In this example, the function replaces HTML tags in a rich text property with plain text, effectively stripping out any applied formatting.