CHAPTER 13
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 ...
Get Extending SSIS with .NET Scripting: A Toolkit for SQL Server Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
