HP Embedded Capture Device License 1-100 E-LTU Uživatelský manuál stáhnout pdf (Strana 29)

●

ItemName LIKE '*product*'

●

ItemName LIKE '*product'

●

ItemName LIKE 'product*'

Wildcard characters are not allowed in the middle of a string. For example, 'te*xt' is not allowed.

Functions

The following functions are also supported:

Table 1-9 Supported functions

Function: LEN

Description Gets the length of a string

Syntax LEN(expression)

Arguments expression -- The string to be evaluated. Could be formed by strings, or by macros that will be

replaced at runtime by its corresponding session data.

Example Len(expression)

Function: ISNULL

Description Checks an expression and either returns the checked expression or a replacement value.

Syntax ISNULL(expression, replacementvalue)

Arguments

expression -- The expression to check.

replacementvalue -- If expression is null, replacementvalue is returned.

Example IsNull(%_CUSTOMPROMPTS_PRICE_%, “price null”)

Function: IIF

Description Gets one of two values depending on the result of a logical expression.

Syntax IIF(expr, truepart, falsepart)

Arguments

expr -- The expression to evaluate.

truepart -- The value to return if the expression is true.

falsepart -- The value to return if the expression is false.

Example IIF(%_CUSTOMPROMPTS_PRICE_%>1000, 'expensive', 'dear')

Function: TRIM

Description Removes all leading and trailing blank characters like \r, \n, \t, ' '

Syntax TRIM(expression)

Arguments expression – The expression to trim.

Example TRIM(‘ hello’) > result will be ‘hello’

Function: SUBSTRING

Description Gets a sub-string of a specified length, starting at a specified point in the string.

Syntax SUBSTRING(expression, start, length)

Arguments

expression – The source string for the substring.

Section 1.4 HP Embedded Capture (HP EC) functionality 19

1 2 ... 24 25 26 27 28 29 30 31 32 33 34 ... 108 109

Žádné komentáře

HP Embedded Capture Device License 1-100 E-LTU Uživatelský manuál Strana 29