replaceAll

replaceAll

This topic describes the syntax and usage of the replaceAll function in Zoho Creator .

Description

The replaceAll function replaces all occurrence of the string that matches the given <searchString> expression with the given <replacementString>.

Syntax

<mainstring>.replaceAll(searchString, replacementString, [escapeRegEx])

(or)

replaceAll(mainstring, searchString, replacementString, [escapeRegEx])

// this format is supported only in the free flow scripting mode of Script builder.

where,
mainstring - Required. Variable containing the string value.
searchString - Required. The substring to be searched for in the main string.
replacementString- Required. The replacement substring.

Note:

  • If the specified searchString or replacementString contains null value, the mainstring ​will be returned without any changes.

By default, the replaceAll() function supports regular expression (i.e) it will not find and replace the special characters like $,* etc., in the source string. The parameter [escapeRegEx] is an optional boolean parameter provided to specify if the regular expression is to be supported or escaped by Zoho Creator, while executing the replaceAll() function.

  • The value true denotes escaping the regular expression support on replace functions.
  • The value false denotes supporting regular expression on replace functions. By default, the value is taken as "false".

Note:

  • If the value for escapeRegEx parameter is not specified, the value we will take as " false". i.e By default, regular expression is supported on replace functions. For example, the following two functions will perform the same operation:
mainString="Create online database applications";
replaceAll(mainString, "online","custom",false);
replaceAll(mainString, "online","custom");

Return Value

Returns the replaced string.

Example

mainString="Jack and Jill went up the hill to fetch a pail of water";
searchString="Jack";
replacementString="Bill";

mainString.replaceAll(searchString,replacementString); //returns "Bill and Jill went up the hill to fetch a pail of water"

 

Address = "Suite 123, 4523 Yonge Street, Toronto";
Address.replaceAll("23","9945"); //returns "Suite 19945, 459945 Yonge Street, Toronto"

 

mainString="Jack and Jill went up the hill to fetch a pail of water";
searchString="Jack";
replacementString="Bill";

replaceAll(mainString,searchString,replacementString); //returns "Bill and Jill went up the hill to fetch a pail of water"

 

Address = "Suite 123, 4523 Yonge Street, Toronto";
replaceAll(Address,"23","9945"); //returns "Suite 19945, 459945 Yonge Street, Toronto"

 

Share this post : FacebookTwitter

Still can't find what you're looking for?

Write to us: support@zohocreator.com