• Text Functions
  • ANSI Character 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
  • Text Functions
  • 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