Abstract
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Ryan Wade
About this chapter
Cite this chapter
Wade, R. (2020). Advanced String Manipulation and Pattern Matching. In: Advanced Analytics in Power BI with R and Python. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5829-3_7
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5829-3_7
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5828-6
Online ISBN: 978-1-4842-5829-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)