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

LTRIM Function

The LTRIM function removes leading spaces (i.e. those to the left) from any variable to which it is applied (i.e. text string, database field, etc.)

Syntax

LTRIM(expression)

Expression

Text String

Example
LTRIM("TEST")

Returns "TEST" with the spaces to the left trimmed from the string.

Database Field

To use a database field with LTRIM function, apply the following expression: (DATABASE -> FIELD)OPERATOR VALUE

Example 1

LTRIM(AM->AC_NO)="108"

Returns only records with account number 108.
Example 2

(LEFT(LTRIM(AM->AC_NO),2)="11"

Returns only accounts that start with "11" (i.e. 11, 110, 111, 112, ..., 1100, 1101, 1102, ..., etc.). Similar to using a wildcard grouping mask 11??.

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.