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
Tim consults for FinTek Development and teaches the course Automating ETL on Udemy. He’s worked with technology since high school, helping his school win its first TCEA award and continues to work in automation, data architecture, back-end development, and smart contract architecture. Tim enjoys testing new technologies early in the diffusion of innovation curve and was an early adopter of NoSQL and smart contract development. He has a blog at http://www.fintekdev.com/ and helps contribute to local technical and financial events in Texas.