Applying the RegEx Filter

The following example illustrates how the RegEx Filter is used:

1. As shown above, a RegEx Filter element is added as a child to a datalayer element.
2. Its Data Column attribute value is set to the column in that datalayer whose value will be examined.
3. The Regular Expression attribute is set to define the desired regular expression code.

Using the example above, the sequence of events is that the datalayer reads in all the data from the datasource, then the RegEx Filter removes all rows whose Freight column values don't match the regular expression pattern (unlimited digits before the decimal point, two digits after it, and no dollar signs, commas, text, or symbols). All that remains in the datalayer for use in the report are rows whose Freight values match the pattern.