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

     

     

     

     

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