The Regular Expressions for MS SQL Server offer an extremely powerful way to search, replace, format and extract text data inside a string using sophisticated search criteria, far above the capabilities of the MSSQL's PATINDEX and REPLACE functions.
Description: The Regular Expressions for MS SQL Server is a set of T-SQL User Defined Functions (UDF) that gives users full power to manipulate string data in SQL queries, stored procedures and Transact-SQL programming. Some of the common challenges that you can solve with the Regular Expressions are:
Extracting information and data mining;
Formatting string data;
Parsing text data into sections;
Validating user text input; password, e-mail, URL, ect.;
Replacing values in text to clean or change content.
Features of the product are:
easy to use;
great productivity and reliability;
100% compatible with VBScript regular expressions;
works with (N)CHAR and (N)VARCHAR data;
30 days free trail period of the full product version.
EasyPattern Helper 3.0 Design perl patterns using point and click! Just highlight the variable text and the text to capture, and EPHelper does the rest! EasyPatterns are a cool new way to describe text
DATSUF 1.0 DATSUF is a set of T-SQL user defined functions that enable to run data analysis queries on top of any version of MS SQL Server. DATSUF can be used within any CLR language or from