Microsoft Idea

Power BI Ideas Admin on 05 Jul 2020 23:09:18

RE: Regular Expressions support in Power Query

This is should be helpful compared to other tools (like Dremio or any other open source tools)

O on 05 Jul 2020 23:05:09

RE: Regular Expressions support in Power Query

Agreed. I will use Python instead of Power Query or M because of this. This is a crucial element to data cleanup and I need this in virtually all of my data files. Very disappointed that M does not support this.

Yan on 05 Jul 2020 22:58:59

RE: Regular Expressions support in Power Query

You can use R to pre-filter using regexp but I am tired of workarounds, especially if cumbersome.
Looking at the recent PBI releases, it seems most changes were made on the front-end rather than more functions in the query/filter engine. Too bad. Note that Tableau, Qlik and Sptfire have regexp implemented for quite some time.

Yan on 05 Jul 2020 22:58:59

RE: Regular Expressions support in Power Query

You can use R to pre-filter using regexp but I am tired of workarounds, especially if cumbersome.
Looking at the recent PBI releases, it seems most changes were made on the front-end rather than more functions in the query/filter engine. Too bad. Note that Tableau, Qlik and Spotfire have regexp implemented for quite some time.