Forum Discussion

Ben_Nash's avatar
Ben_Nash
Frequent Visitor
10 years ago
Solved

Extract url from text in DAX

Hi everyone   I'm trying to extract urls from twitter messages and placing in another column using DAX. I've been using this formula in excel to extract and it works fine:   =MID(A1,FIND("http",A...
Need Help
  • Ben_Nash's avatar
    Ben_Nash
    10 years ago

    Hi Matt and Baskar - I've followed your suggestion Matt and sorted the problem starting from Query Editor>Transform>Split Column>By Delimiter>Custom>"https".

     

    Thanks again!

     

    Cheers

     

    Ben

     

     

     

     

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

I agree, you need to post an example. But I also think this is a task for data shaping in power query (get data) and not DAX. 

  • Ben_Nash's avatar
    Ben_Nash
    Frequent Visitor
    10 years ago

    Hi

     

    Thanks for getting back to me and good point on power query.

     

    Screen grab of examples below - as you can see the urls aren't always in the same spot:

     

     

     Thanks 

     

    Ben

    • MattAllington's avatar
      MattAllington
      Icon for Community Champion rankCommunity Champion
      10 years ago

      How about using power query to split column on colon :  then rebuild the URL http:// from there

      • Ben_Nash's avatar
        Ben_Nash
        Frequent Visitor
        10 years ago

        Hi Matt

         

        Thanks for this - will do. Apologies for my ignorance but is there anyway I can bring across to power query the actual excel formula I have?

         

        Regards

         

        Ben