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

       

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

        No way unfortunately. But using the power query UZi is much easier than writing Excel formulas.