Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Add regular expression support to as native database feature

NULL
Status: New
Comments
colinbanfield
New Member
Very important feature for more complex cleansing and validation
evans2
New Member
Please include this feature. It would be incredibly useful.
i_feldmann
New Member
Strongly vote for this feature. There is a demand for it out there. See 3 Posts in Forum within 1 week: 1) https://social.technet.microsoft.com/Forums/en-US/c83672a9-c208-4b29-872e-4032fdec67f3/regular-expressions-in-power-query?forum=powerquery 2) https://social.technet.microsoft.com/Forums/en-US/8f5ae2d5-b801-4c25-be95-330d60f46d68/power-query-regular-expression-capability?forum=sqlkjpowerpivotforexcel 3) http://www.mrexcel.com/forum/power-bi/871103-email-validation-part-sql-query.html (Strange that this post doesn't show up when entering "regular expression" as the keyword in the main search. You have to search in search box on the right navi area. Could this be adjusted?)
jade_wilderthem
New Member
Yes, this would be extremely helpful.
ravrav
New Member
Please include ASAP regular expression functionality in Power BI. It extremely short development time with DWH and NoSQL etc It will be greatest feature to fliter, clear and stlit data in ETL process. Extremely helpful to validate alse. Thanks.
steve34
New Member
RegEx would be a deal maker! I'd also add a whole bunch of functions, eg, Soundex, Levenshtein etc. I'm still new to Power Query and wonder if i can add functions using "M". If so, then it would be neat if somebody could start are library of these. Similarly, i already use a VBA library of such functions inc RegEx in MS Access. Makes sense to have something similar in Power BI.
bertrand_d-arb1
New Member
Excel users do not have access to R scripting in Power Query. This feature would be even more useful to them.
g5gwies4_dax
New Member
This is completely necessary !!! I need to replace a column that "contains" certain data (not the complete occurrence) this is so basic!! please implement it ASAP!! this has been here for so long !! 3 years and you can't put it ?!!
fbcideas_migusr
New Member
Status changed to: New