In my previous blogpost I’ve described a method how to extract a substring that follows a certain pattern from a string. In this post I show how to transform a (…) Read more
Posts Tagged ‘Regex’
Extract pattern string and numbers from text using List.Accumulate in Power Query
A typical task when cleaning data is to extract substrings from string that follow a certain pattern. In this post I’m going to describe a method that uses the List.Accumulate (…) Read more