Forum Discussion

JamesH245's avatar
JamesH245
Frequent Visitor
7 years ago
Solved

Creating new column from url split?

Didn't really know how to word the title, but I want to parse different urls. In each url, it's strucured like so:

 

https://website.com/Forums/en-US/54235365243/forum=FORUMTAG

 

I want to take "FORUMTAG" , which is always different, and create a column with the values in it. Basically just adding "FORUMTAG" to the same row as the url. How can I do this? :) 

 

Thanks!

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    In power query you can split by delimiter. Change the delimiter to "=" and last occurrence. Probably the easiest way of going about it. 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    In power query you can split by delimiter. Change the delimiter to "=" and last occurrence. Probably the easiest way of going about it.