Altova MapForce 2026 Enterprise Edition

Creates a BSON regular expression (as a bson:regex) from a search pattern and a string of matching rules (options).

Languages

Built-in

Parameters

Options

The following options are supported:

•i (Case-insensitive): Matches both upper- and lowercase letters (e.g., A matches a).

•m (Multiline): Makes anchors ^ and $ match the start and end of each line, rather than the start and end of the entire string.

•s (Dotall): Allows the dot (.) character to match everything, including newline characters.

•u (Unicode): Enables Unicode support for shorthand character classes like \w (word characters) and \d (digits).

•x (Verbose): Ignores whitespace within the pattern and allows for comments (starting with #), which makes complex patterns easier to read.

Example

This example shows how to use the to-regex function to filter MongoDB data (see screenshot below). Our goal is to filter information about racing teams and output only those teams with "Mercedes" in their names:

1.First, we set the SQL/NoSQL WHERE/ORDER component as follows:

oFilter:

{

 "name" : @name

}

oThe name parameter is defined as a regex type because it receives the BSON regular expression from the to-regex function.

oThe filtered results are set to be sorted by the name field in ascending order.

2.Second, we add the to-regex function and define its parameters:

oPattern: .*mercedes.*, where .* matches any character zero or more times.

oOptions: i, which means the search is case-insensitive.

3.Third, we connect the result of the to-regex function to the name parameter of the SQL/NoSQL WHERE/ORDER component to execute the search.

As a result, we get the following output: