• 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