Panorama > Formulas > Text Formulas
 
textstuff(
textstuff(
MAINTEXT
,
NEWTEXT
,
POSITION
)

The textstuff( function replaces one or more characters in the middle of a piece of text.

Parameters

This function has three parameters:

maintext – the original text data item that contains one or more characters you want to replace.

newtext – is the new text that you want to use to replace characters in the original text data item.

position – is the location within the original text where you want to replace text. The position is a number starting with zero (not 1 like text funnels and most other text functions).

Description

The textstuff( function replaces one or more characters in the middle or at the end of a piece of text. The function allows you to specify where in the original text the characters are to be replaced, and what the new characters should be.

textstuff("Temperature: 87 degrees"," 92",12) ☞ Temperature: 92 degrees

If the new text is positioned beyond the end of the original text, the characters in between will be filled in with spaces.

textstuff("Temp:"," 92",12) ☞ Temp:        92

See Also

History

VersionStatusNotes
10.0UpdatedCarried over from Panorama 6.0, but if the new text is "hanging" off the end of the existing text the extra space in between will be filled in with space characters (in previous versions the content of these characters was undefined).