Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Regex with R Script

Hi, I have a table containing Postal code and the regex pattern this postal code should follow to be correct. What I want is a new column saying if the Postal code is matching the Pattern provided ...
Need Help
Tips and Tricks
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Anonymous ,

You can refer these two articles which introduce regular expression in details in power query, hopes it could help.

  1. Using Regular Expressions(RegEx) in Power BI 
  2. Power BI and Regular Expressions 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

Thanks, but these are reffering to manually input of the pattern. This is working if you are focusing on only a few patterns, not when you have 200+ patterns. 😞