You are here: All Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > SCANSTR function

SCANSTR function

The SCANSTR function evaluates the position of one string value (value 1) within another string value (value 2).

Syntax

SCANSTR(value 1, value 2)

Example 1

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

Returns a value of 10.

Example 2

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

Returns a value of 0.

Database Filter Syntax

SCANSTR(DATABASE -> FIELD, string), OPERATOR VALUE

If the SCANSTR function finds the matching string, it returns a value for the position of that string. Therefore, if the string exists in a field the value returned will NOT be 0. Therefore a filter,

Example

SCANSTR(GL->JE_DESC,"BUDGET")>0

Returns any journal with a description line that contains, and matches exactly, the text string "BUDGET". The IN function could be used in the same way.

Operator	Description	Syntax	Example
<	Less than	value 1<value2	C1<C2 Condition is true if cell 1 is less than cell 2.
<=	Less than or equal to	value 1<= value2	C1<=C2 Condition is true if cell 1 is less than or equal to cell 2.
>	Greater than	value 1 >value2	C1>C2 Condition is true if cell 1 is greater than cell 2.
>=	Greater than or equal to	value1>=value2	C1>= C2 Condition is true if cell 1 is greater than or equal to cell 2.
=	Equal to	value1=value2	C1=C2 Condition is true if cell 1 is qual to cell 2.
<>	Not equal to	value1<>value2	C1<>C2 Condition is true if cell 1 idoes not equal cell2.

Filter Type	Database
Financial Statement	AM Database
Journal or Ledger	GL Database

SCANSTR function

Database

Field

Comparison Operators

Value