Click or drag to resize
Text data type
Print this page

The data type Text represents a string value.

Usage
[Output]
LastName = input.Surname
Field length

The effective maximum length of this data type, if not specified, is 1 GB (less, if column is indexed).

JavaScript conversion

When you use the optional [Script] section to insert your own JavaScript functions, note that Text maps to JavaScript String, with native string assignment and full use of string functions.

Creation
JavaScript
var myText = "string";
Methods

These are the native JavaScript methods for String objects:

  • charAt() — Returns the character at the specified index

  • charCodeAt() — Returns the Unicode of the character at the specified index

  • concat() — Joins two or more strings, and returns a copy of the joined strings

  • fromCharCode() — Converts Unicode values to characters

  • indexOf() — Returns the position of the first found occurrence of a specified value in a string

  • lastIndexOf() — Returns the position of the last found occurrence of a specified value in a string

  • match() — Searches for a match between a regular expression and a string, and returns the matches

  • replace() — Searches for a match between a substring (or regular expression) and a string, and replaces the matched substring with a new substring

  • search() — Searches for a match between a regular expression and a string, and returns the position of the match

  • slice() — Extracts a part of a string and returns a new string

  • split() — Splits a string into an array of substrings

  • substr() — Extracts the characters from a string, beginning at a specified start position, and through the specified number of character

  • substring() — Extracts the characters from a string, between two specified indices

  • toLowerCase() — Converts a string to lowercase letters

  • toUpperCase() — Converts a string to uppercase letters

  • valueOf() — Returns the primitive value of a String object