Return a portion of text (formerly called “Substring”).

Input Fields

  • text: The text containing the segement you want to extract.
  • start at: The position of the first character you want to extract in ‘text’ where 0 is the first character, 1 is the second, and so on.
  • end before: The position one greater than the last character you want to extract. If left blank or the number is greater than or equal to the length, it will extract all the way to the end. If end before is less than start at, the arguments are swapped.

Output Fields

  • segment: The extracted text segement as specified

Examples:

If ‘text’ is Example:

  • start at 0 and end before 2 -> segment Ex
  • start at 2 and end before left empty -> segment ample
  • start at 3 and end before 5 -> segment mp