Range/Locate Window (Magic xpa 2.x)
You can access the Range/Locate window by selecting Range/Locate from the Task menu or pressing Ctrl+R.
This window lets you choose from three groups of ranges:
Range – You can define a single data view range by entering values in the From and To columns or select several ranges for a single field by specifying the same field in a new row. Every row is evaluated by an expression before the task opens.
SQL Where Clause – This window lets you specify a range for Magic xpa or DB SQL Where, view the Full Where Clause that is generated by Magic xpa, and write a range based on SQL syntax using Magic xpa variables.
Range Expressions – You can use the Range expression to fine-tune a task’s data view. The rows are initially included in a data view based on the From-To expressions specified in the task’s Range From-To window. The Range Expression lets you to define the Range further, by entering complex and dynamic conditions and is evaluated for every fetched record.
Note:
-
A question mark (?) used in the main source's range or locate is used as a wildcard character. It represents any single character.
-
The asterisk (*) character used in the main source's range or locate is used as a wildcard character. It represents a string of characters.
-
To use the asterisk or question mark as a value in the range or locate, precede the asterisk or question mark with a backslash (\). Since version: 1.9h
Examples of range and locate syntax:
-
a* will do the range or locate on a* (where * is a wildcard character)
-
a\* will do the range or locate on a* (where * is a string)
-
a\\ will be a\
-
a\\* will do the range or locate on a\* (where * is a wildcard character)
-
a\b will remain a\b
