Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

PowerShell Regular Expression (RegEx) Video Examples for SQL Server


By:   |   Last Updated: 2014-09-29   |   Comments   |   Related Tips: 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


next webcast button


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




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools