Tips & Tricks

Replace (IntelliCalcs Function)

1 minute read

Description

This function replaces text within Field that matches RegularExpression with ReplaceWith

 

Syntax

Replace (RegularExpression, Field, ReplaceWith)

 

Parameters

Name Data Type Description
RegularExpression Character
Field Character
ReplaceWith Character

 

Example

Name Formula Value
MyReplace1 Replace(“Now”, “How Now Brown Cow”, “Hello”) “How Hello Brown Cow”
MyReplace2 Replace(“[0-9]”, TaxCode, “”) ‘

 

Last update

7 February 2022

Procentia Support

Related