Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Regular Expressions Rss

Search for any content tagged regular expressions

   Items 1 to 10 of 10   
 

RegEx for DBAs

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...
By David Poole 2014/09/05 (first published: 2012/05/08) | Source: SQLServerCentral.com | Category: regex
Rating: |  Discuss |   Briefcase | 18,294 reads

Finding special characters within character strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2014/08/19 | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 9,476 reads

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,504 reads

Regular Expression Transformation

The regular expression transformation exposes the power of regular expression matching within the pipeline. One or more columns can be selected, and for each column an individual expression can be applied. The way multiple columns are handled can be set on the options page.  Read more...
By Additional Articles 2012/08/10 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 3,299 reads

RegEx for DBAs

RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions  Read more...
By David Poole 2014/09/05 (first published: 2012/05/08) | Source: SQLServerCentral.com | Category: regex
Rating: |  Discuss |   Briefcase | 18,294 reads

Using Regular Expressions to Convert PL/SQL code to T-SQL

When converting Oracle PL/SQL to T-SQL, there are a number of ways to do this, but this article shows us how this can be done with regular expressions in Management Studio.  Read more...
By P. Praveena 2013/04/19 (first published: 2011/10/11) | Source: SQLServerCentral.com | Category: regular expressions
Rating: |  Discuss |   Briefcase | 9,504 reads

How To Use Regular Expressions for Data Validation and Cleanup

You need to provide data validation at the server level for complex strings like phone numbers, email addresses, etc. You may also need to do data cleanup / standardization before moving it from source to target. Although SQL Server provides a fair number of string functions, the code developed with these built-in functions can become complex and hard to maintain or reuse.  Read more...
By Additional Articles 2011/03/03 | Source: MSSQLTips.com | Category: regular expressions
Rating:  Rate this |   Briefcase | 14,628 reads

RegEx-Based Finding and Replacing of Text in SSMS

So often, one sees developers doing repetitive coding in SQL Server Management Studio or Visual Studio that could be made much quicker and easier by using the Regular-Expression-based Find/Replace functionality. It is understandable, since the syntax is odd and some features are missing, but it is still worth knowing about.   Read more...
By Additional Articles 2011/02/04 | Source: SimpleTalk | Category: management studio (ssms)
Rating:  Rate this |   Briefcase | 3,514 reads

Dynamically Map Column Data Based on Column Pattern Profiling

Tutorial on using Script Component, Regular Expression and derived Column Transform to dynamically map different source column types into the appropriate target column for address data.   Read more...
Rating: |  Discuss |   Briefcase | 2,385 reads

TSQL Regular Expression Workbench

This Workbench is about using Regular expressions with SQL Server via TSQL. It doesn't even attempt to teach how regular expressions work or how to pull them together. There are plenty of such resources on the Web. The aim is to demonstrate a few possibilities and try to persuade you to experiment with them if you don't already use Regex with SQL Server.  Read more...
By Additional Articles 2007/12/10 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 4,063 reads
   Items 1 to 10 of 10