As long as you have some consistency its pretty simple to build a formula around this. Instead of fully explaining it, below I have linked a sample.
There are 2 fields which find each of the “.” in the url. You don’t need these to be formulas, you can build it into the other formulas but I thought for simplicity of showing this would work best. The other formulas check against the “second .” field to see if there is a second “.”. It then runs the LEFT, MID, or RIGHT formula to extract the information using the positions of the “.”
