O'Reilly logo

Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services by Régis Baccaro, Joost van Rossum

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 13

image

Regular Expressions

Many ETL applications and processes usually deal with strings or have to parse large amounts of text; it is not unusual to be in a situation where you want to strip some elements from a block of text or to validate that an email address is in a valid format.

Regular expressions provide a flexible, powerful, and efficient method for processing text. The regular expression pattern-matching engine enables you to

  • Parse large amount of texts to find specific character patterns
  • Validate text to ensure that it matches a predefined pattern
  • Extract, edit, or delete text substrings and to add these substrings in a collection ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required