Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Help formatting all websites the same

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.

"DAX help"
'Need help' 'DAX'
Conditional Formatting column
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.