Skip to content

Character at position / first / last / random (text_charAt)

What it does: Returns one character from the text according to the selected mode.

text_charAt

Inputs

  • VALUE: input text.
  • AT: index (only for modes with specific positions).
  • Setting the WHERE block: FROM_START, FROM_END, FIRST, LAST, RANDOM.

Output

  • Text (one character).

When to use it

  • Check prefix/suffix.
  • Simple character-by-character parsing of text logs.

Tips and pitfalls

  • For empty text, access to a character may result in an error.
  • Watch the index range, especially for short texts.
  • RANDOM uses random selection so the output is not deterministic.