I'm currently using the following formula =LEFT([LandingPageURL],SEARCH("?",[LandingPageURL]))
The idea is this just takes all the characters in LandingPageURL up to the question mark, however the result of the search is always 1, so I'm assuming question mark is a wildcard here. If it is, is there a way to not use it as a wildcard? I've tried to 'escape'/'literal' the ? character with backslash within the quotation marks and outside, but it still doesn't work. Any ideas?