Marco on 16 Jul 2015 14:17:27
We think regexp support will help the adoption of the Power Query tool in the most demanding use cases. Many thanks.
- Comments (76)
- Merged Idea (2)
RE: Regular Expressions support in Power Query
Having Regex withing PowerBI query editor will be an added advantage for data clean up and transformation
RE: Regular Expressions support in Power Query
Doing replaces on strings using REGEX would be so beneficial for data transformations.
RE: Regular Expressions support in Power Query
So desperate for this. I have a complex regex for processing text which contains complex array data that I get from another data source. To replicate this using native M functions will be a nightmare. Report server doesn't allow R or Python scripts to be run, which would prevent auto refresh. Very frustrating. I would have thought it would be a basic function. Just integrate an existing REGEX library from python or somewhere into the M language, and have it iterate over one text cell at a time in a column.
RE: Regular Expressions support in Power Query
Python is a good workaround but it does not work if you are going to schedule report refresh on server side. Vote for Regex in Power Query M.
RE: Regular Expressions support in Power Query
Yes, vital! Workarounds using R and Python scripting then prevent scheduled refresh without personal gateways, which is a non-starter for several reasons.
RE: Regular Expressions support in Power Query
Very surprising this thread exists. Better late than never.
RE: Regular Expressions support in Power Query
Regex in Advanced Filters is a must. Current text filtering options are not so good.
RE: Regular Expressions support in Power Query
This is a mandatory feature. The alternatives and workarounds are unacceptable and I feel we are severely limited by its absence.