March 2018
Beginner to intermediate
570 pages
13h 42m
English
Suppose you find that there are commas separating every third digit of the numbers in a numeric column. How would you remove them? Or suppose you needed to strip a currency symbol from values in columns that hold monetary values so that you can compute with them as numbers. These, and vastly more complicated text transformations, can be performed using a most powerful tool, regular expressions.