I’m not super well versed in formula writing but have tried quite a few things. While the first portion of the original string (ending with “the-project/”) is always that exact number of characters (80 in this example), the issue I keep having is that the portion I want to extract isn’t a specific number of characters (it’s always different). And I also don’t want to include the “.html” portion at the end.
Can anyone help me figure out:
A. How to extract the exact portion of text that I want?
B. How to add it to the end of the new string?
C. How to do all this with one formula field?