User Tools

Site Tools


syntax:functions:strip

Strip(text)

Category: Text function


Description

This function removes the first and the last characters from a text value.


Use cases

This function is typically used to remove wrapping characters such as quotes, parentheses, or brackets.


Arguments

ArgumentTypeDescription
textTextAny text value. Numeric values are not implicitly converted. See Remarks, below.

Return value type: Text


Remarks

It is not implied that the characters being removed have to be matching. Regardless of what the leading and trailing characters are, they will be removed.

Passing a numeric value into this function will have no effect (the value will be returned unchanged). Numeric values are not implicitly converted to text in this function. To use Strip on a number, convert the number to text first using the AsText(value) function.


Examples

strip('<table>') //Returns 'table'
strip('(house)') //Returns 'house'
strip('another') //Returns 'nothe'
strip('120012') //Returns '2001'
strip(10001) //Returns 10001  (Numeric values are returned unchanged)
strip(astext(10001)) //Returns '000'  (Convert numbers to text first)
syntax/functions/strip.txt · Last modified: 2021/08/14 22:27 by craigt