Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
I have a column with a bunch of website links that are all formatted differently so extract and split column aren't working as it just removes all other websites that don't follow that format.
I have websites starting with:
https://www. or http:// or www. and some with no beginning to the link. Then some of the web links end with a / after the .com
I'm wanting all websites to be formatted as domains so it would just be: websitename.com
I'm not sure how to do this with a conditional column, custom column, calculated column or what. If I use split or extract it just messes everything up and makes things even more different. Any ideas? Please see reference picture to see what I'm working with.
Solved! Go to Solution.
I found my own solution by splitting the column by deliminators multiple times to get the part of the weblink I needed then merged the columns with the resulting format I was looking for. If you know of an easier way let me know but this worked.
I found my own solution by splitting the column by deliminators multiple times to get the part of the weblink I needed then merged the columns with the resulting format I was looking for. If you know of an easier way let me know but this worked.