Matches any single character except newline character “ \n” X$ – This pattern matches any line that ends with “ X” character Matches the end of the line (or any line, when applied in multiline mode) ^B – This pattern matches any line that starts with “B” character Matches the start of the line (or any line, when applied in multiline mode) Here is the list of the most commonly used regular expressions: The /exclude switch is processed after the /include switch. Multiple excludes can be specified with spaces in between. exc – Exclude specific objects in processing, objects can be specified by first specifying a bitwise set and after “ :” a regular expression. If the /inc switch is not specified, all objects are assumed inc – Specifies the objects to be compared using regular expressions These switches accept regular expression patterns as parameters and act the way similar to the Object filter feature. Using regular expressions in the Command Line Interface switchesĪpexSQL Data Diff, ApexSQL Diff, ApexSQL Diff for MySQL, ApexSQL Doc and ApexSQL Script support a set of Command Line Interface switches for including into and excluding objects from the process. Using regular expressions for database text searchĪpexSQL Search supports regular expressions to match the results in the Filter row option: In the Find window, select the Use regular expressions option and enter the regular expressions pattern: In the ApexSQL Log toolbar, under the Home tab, click the Find option: Using regular expressions for filtering the Results grid in ApexSQL LogĪpexSQL Log has a custom search feature that supports regular expressions. For example, the set containing the three strings Handel, Händel, and Haendel can be described by the pattern “H(ä|ae?)ndel”. NET framework regular expressions in ApexSQL tools.Ī regular expression is a string that is used to describe or match a set of strings, according to certain syntax rules. ApexSQL Data Diff, ApexSQL Diff, ApexSQL Diff for MySQL, ApexSQL Doc, ApexSQL Log, ApexSQL Script and ApexSQL Search