Replace
This article describes the formula syntax and usage of the REPLACE function in GoFormz.
Description
REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.
Syntax
REPLACE(text, startNumber, numberOfCharacters, newText)
The REPLACE function syntax has the following arguments:
- text (Required) Text in which you want to replace some characters.
- startNumber (Required) The position of the character in old_text that you want to replace with new_text. The first character begins at position 0.
- numberOfCharacters (Required) The number of characters in old_text that you want the REPLACE function to replace with new_text.
- newText (Required) The text that will replace characters in old_text.
Example
Created fields with the following names and Default Values:
Field 1: abcdefghijk
Field 2: 2009
Field 3: 123456
| Formula | Description (Result) | Result |
|---|---|---|
| =REPLACE([Field 1],5,5,"*") | Replaces five characters in abcdefghijk with a single * character, starting with the fifth character (f). | abcde*k |
| =REPLACE([Field 2],2,2,"10") | Replaces the last two digits (09) of 2009 with 10. | 2010 |
| =REPLACE([Field 3],0,3,"@") | Replaces the first three characters of 123456 with a single @ character. | @456 |
Updated almost 2 years ago