In the following locations, you can use Regular Expressions to exclude tables named in a specific way:
The following is an explanation of the Regular Expression system used by the CAST Transaction Configuration Center and some examples of how to use it.
System in use
The CAST Transaction Configuration Center uses the Java Regular Expression system - you can find out more about this here: https://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html
|String searched||Regular expression to enter|
|Strings containing "src"||src|
|Strings exactly matching "src"||^src$|
|Strings starting with "src"||^src|
|Strings ending with "src"||src$|
|A string exactly matching "src"||/src$|
|A string exactly matching ".src"||/\.src$|
|One or more upper case letters, but not zero||[A-Z]+|
|Any sequence of characters or any length - i.e. match all tables||.*|
Number of characters
You can enter a Regular Expression of up to 500 characters.
Please note that by default the CAST Transaction Configuration Center matches only part of the string corresponding to the Regular Expression you have entered, rather than the entire string. As such to match an entire string please use the ^ and $ characters around the required string.
Please note that the following characters are "reserved characters" and therefore must be "escaped" with a backslash before being used in a Regular Expression:
. ( ) [ ] ^ $
So, for example to match for an item (a folder in this case) entitled ComplexityVolume(PercentageofLOC), you will need to enter ^ComplexityVolume\(PercentageofLOC\) in the Regular expression field.
Please see the section entitled "Backslashes, escapes, and quoting" in https://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html for more information.
If your CAST databases are hosted on a Microsoft SQL Server, the Regular Expression features will not function in an "out of the box" setup. To enable the feature you need to do the following:
sp_configure 'show advanced options', 1 go RECONFIGURE go sp_configure 'clr enabled' , 1 go RECONFIGURE go CREATE ASSEMBLY SearchPattern from 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\CAST.DotNet.SearchPattern.dll' go CREATE FUNCTION dbo.REGEXP_LIKE ( @subject nvarchar(4000), @pattern nvarchar(4000), @option nvarchar(255) ) RETURNS int AS external name SearchPattern.SearchPattern.SearchRegexPattern go
Once the above steps are complete, you should now be able to use the Regular Expression features when working with a Microsoft SQL Server.