Complex IF Comparisons

Complex If Comparisons are used to make multiple comparisons in the same line in addition to performing more complex math. For example, a single line could check to see if a date is less than one date AND greater than another date. In order for the complex If comparison to be evaluated properly, the expression must be inside parentheses. The complex If comparisons also allow evaluate if an expression is NOT true.

Note: The symbols =, <>, >, >=, <, <= are only supported if the entire If construction is between parentheses.

The same mathematical operators (+, -, /, *) are supported in the complex If structure, but there is no restriction to the number of operations that are performed. Additional parentheses can be used to added.

When using the special comparison operators in complex If comparisons, the comparison operators must appear inside parentheses (See Samples below). Operators must be followed by another set of parentheses and any parameters must be inside the parentheses and separated by commas.

IsAllAlpha(<StringExpression>)	Returns True if all characters are letters, see also IsAllAlpha
IsAllNumeric(<StringExpression>)	Returns True if all characters are numeric digits, see also IsAllNumeric
IsAllAlphaNumeric(<StringExpression>)	Returns True if all characters are a mix of letters & numeric digits, see also IsAllNumeric
EOF()	Returns True if the end of the input file has been reached.
EndOfLine()	Returns True if there is no more data in the current record.
EndOfList(<ListName>)	Return True if the end of the specified list has been reached. See also EndOfList. Note: List Name must be inside double quotes.
ListExists(<ListName>)	Return True if the specified list exists. See also ListExists. Note: List Name must be inside double quotes.
FileExists(<PathAndFileName>)	Returns True if the file exists, see also FileExists
FileIsReady(<PathAndFileName>)	Returns True if the file exists and can be opened for reading, see FileIsReady
IsDate(<StringExpression>)	Returns True if the <StringExpression> is a date, see also IsDate
Like(<StringExpression>, <Pattern>)	Returns True if the <StringExpression> fits the <Pattern>, see LIKE.
Mod(<Number1>, <Number2>)	Returns the remainder when <Number1> is divided by <Number2>
FindString(<String1>, <String2>)	Returns the position of the first occurrence of <String2> within <String1> See also, FindString.
ObjectExists(<ObjectName>)	Returns True if the object exists, see also ObjectExists
CheckS(<String>," *" or <row>, <col>)	This function works like Check S. However, the parameters must appear inside parentheses and should be separated by commas. Note: If the asterisks () is to be used, it should appear between quotes. Sample: If (CheckS("PATIENT MANAGEMENT", "")) THEN ... EndIf
Length(<String>)	Returns the length of the string.
IN(Value, Value1, ...ValueN)	Returns true if Value (the first value listed) appears in the subsequent list of values. This search is case-sensitive.
WebElementExists(<ElementID>,<Timeout>)	Returns True if the web element exists, see also WebElementExists
WebElementAllowsFocus(<ElementID>,<Timeout>)	Returns True if the web element exists, see also WebElementAllowsFocus
ElementExists("AppName",<ElementID>,<Timeout>)	Returns True if the windows element exists, see also ElementExists
ElementAvailable("AppName",<ElementID>,<Timeout>)	Returns True if the windows element is enabled, see also ElementAvailable

Note: If a numeric value is being compared to a string, the comparison will be a string (alphabetical) comparison. If two numeric values are compared, they will be compared as numbers even if one or both is in quotes. Therefore, "0" would be considered equal to "000" in both the standard comparison and the complex comparison. This behavior maintains backward compatibility with OLIE.

The following example checks to see that you are not at the end of the input file.

The following example checks the existence of a file and if it does not exist, the script ends with an ExitError.

The following example checks to see if the date, ChgDate, is between two specific dates.

The following example checks the existence of a webelement and if it does not exist, then log an error message.

The following example checks to see if we are NOT at the end of a list. Please note that the list name must be inside double quotes.

The following example checks to see if the value of TransCd is contained in the subsequent list of numbers.