PowerShell Regular Expression (RegEx) Video Examples for SQL Server


By:   |   Updated: 2014-09-29   |   Comments   |   Related: More > PowerShell




 






Enter your business email address to
get free SQL Server tips.

Problem / Solution

In this video tip, we look at how to use RegEx to find patterns in data strings to look for such things as credit card numbers, SSNs or other string patterns.  Tim walks through several examples of how to use RegEx.

Key Learning Items
  • Basic understanding of RegEx to find patterns in strings
  • Using PowerShell to find and replace strings using RegEx
Read Companion Tip

Click Here



Last Updated: 2014-09-29


get scripts

next tip button



About the author
MSSQLTips author Tim Smith Tim Smith works as a DBA and developer and also teaches Automating ETL on Udemy.

View all my tips
Related Resources





Comments For This Article





download





Recommended Reading

Setting the PowerShell Execution Policy

How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger

Using PowerShell to Work with Directories and Files

Bulk Copy Data from Oracle to SQL Server

Execute SQL Server Stored Procedures from PowerShell








get free sql tips
agree to terms


Learn more about SQL Server tools