REPLACE (PQL - xl)

This function replaces part of a text string with a different text string, based on the number of characters you specify

  • Library: PQL \ Spreadsheet \ Text
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
  • Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions

Syntax

REPLACE(old text, start num, num chars, new text)

Function Arguments

Name

Description

Type

Optional

old text

Original text in which you want to replace characters

String

start num

Starting position in the original text to begin the replacement

Number

num chars

Number of characters in the original text that you want to replace with characters from the new text; if not an integer, the number is truncated

Number

new text

New text that replaces characters in the original text

String

Comments

This function is the same as the Microsoft Excel 'REPLACE' function - using the same inputs, logic and outputs.