Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can I use REGEX in Replace Values?

Hello

Can I use regex or wildcards to replace values in Power Query?

Thanks

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    As far as I know, no. Not directly at least. It can be done, I believe, using python. A surrogate function can be found at this link ... but it needs to be tested.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    I'm afraid not.

    How about using Text.Contains? Can it meet your requirements?

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.