Skip to main content

String Manipulation Functions

AMPS provides a set of functions for manipulating strings.

SUBSTR​

SUBSTR​

SUBSTR(string, starting_position, [length])

Returns a portion of the input string, starting at the starting_position and ending after the specified length.

Parameters

  • string: The string to process.
  • starting_position: The 1-based position to start the substring. A negative number counts backward from the end of the string.
  • length: Optional. The length of the substring. If not provided, returns the rest of the string.

Returns

The extracted substring.

Example

The following expressions are all TRUE:

SUBSTR("fandango", 4) == "dango"
SUBSTR("fandango", 1) == "fandango"
SUBSTR("fandango", -2) == "go"
SUBSTR("fandango", 1, 3) == "fan"
TRIM​

TRIM​

TRIM(string, [characters_to_trim])

Returns the input string, with all leading and trailing characters in the set of characters_to_trim removed.

Parameters

  • string: The string to transform.
  • characters_to_trim: Optional. The set of characters to trim. Defaults to a space.

Returns

The trimmed string.

Example

TRIM("   Lancelot   ", " ") == "Lancelot"
LTRIM​

LTRIM​

LTRIM(string, [characters_to_trim])

Returns the input string, with all leading characters in the set of characters_to_trim removed.

Parameters

  • string: The string to transform.
  • characters_to_trim: Optional. The set of characters to trim. Defaults to a space.

Returns

The left-trimmed string.

Example

TRIM("   Lancelot   ", " ") == "Lancelot   "
RTRIM​

RTRIM​

RTRIM(string, [characters_to_trim])

Returns the input string, with all trailing characters in the set of characters_to_trim removed.

Parameters

  • string: The string to process.
  • characters_to_trim: Optional. The set of characters to trim. Defaults to a space.

Returns

The right-trimmed string.

Example

TRIM("   Lancelot   ", " ") == "   Lancelot"
LEFT​

LEFT​

LEFT(string, number_of_characters)

Returns the leftmost number_of_characters from the provided string.

Parameters

  • string: The string to process.
  • number_of_characters: The number of characters to return from the left.

Returns

The leftmost characters of the string.

Example

LEFT("fandango", 3)  == "fan"
RIGHT(string, number_of_characters)

Returns the rightmost number_of_characters from the provided string.

Parameters

  • string: The string to process.
  • number_of_characters: The number of characters to return from the right.

Returns

The rightmost characters of the string.

Example

RIGHT("fandango", 2) == "go"
REVERSE​

REVERSE​

REVERSE(string)

Returns the provided string in reverse.

Parameters

  • string: The string to process.

Returns

The reversed string.

Example

REVERSE("fandango") == "ognadnaf"