• Text Functions
  • Text Functions
  • CLNTDIR function
  • CLNTNAME function
  • CURRENCY function
  • DOCPATH function
  • IN function
  • LEFT function
  • LENGTH function
  • LOWER function
  • LTRIM function
  • MID function
  • MKSTR function
  • PRGDIR function
  • RIGHT function
  • SCANSTR function
  • SPACE function
  • STR function
  • SUBSTR function
  • TITLE function
  • TOKEN function
  • TOKENSUB function
  • TRIM function
  • TRIMRTF function
  • UPPER function
  • XRND function
  • XWKS function

SCANSTR Function

The SCANSTR function evaluates the position of one string value (substring) within another string value (text). Use this function to extract a specific portion of an existing string, or to evaluate if text exists within the specified string.

Syntax

SCANSTR(substring, text)

Example 1

SCANSTR("Ontario","Toronto, Ontario")

Returns a value of 10, the start position of the string value specified within the larger string.

Example 2

SCANSTR("Alberta","Toronto, Ontario")

Returns a value of 0, since the string value specified does not exist in the larger string.

Related Topics

• Text Functions