Advanced String Manipulation and Pattern Matching
Ryan Wade · Apress eBooks · 2020
Many basic string manipulation and pattern matching tasks can be handled using one of the many string functions that come pre-package in Power Query. You can get to many of these functions from the graphical interface, and they are also available for use in calculated columns. These functions work great for simple situations but are not sufficient in many advanced scenarios. Fortunately, R and Python have advanced tools that enable you to perform advanced string manipulation and pattern matching tasks that are beyond the capabilities of Power Query.