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

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

Ben_Nash's avatar
Ben_Nash
Frequent Visitor
10 years ago

Thanks Matt - I'll give it a go in Power Query

 

Regards

 

Ben

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    10 years ago

    Hey Ben ,

     

    Do u want like this ?

    • Ben_Nash's avatar
      Ben_Nash
      Frequent Visitor
      10 years ago

      Hi

       

      I'm giving the Power Query option a go but your screen shot look good - basically where ever there is a url it gets taken out and put in another column (s).

       

      Thanks

       

      Ben

       

       

      • Ben_Nash's avatar
        Ben_Nash
        Frequent Visitor
        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