Text Processing: Is Question Mark character a wildcard?

mattyh · June 19, 2014 6:13AM

Hi Everyone,

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?

Thank you in advance, Matt

paola · June 19, 2014 6:27AM

If your data is consistent, it might be faster to use Expand values block and use "?" as a separator?

mattyh · June 19, 2014 6:41AM

Thanks Paola, you're right it was.

Just in case I ever need it in the future, is there a way to treat a question mark not as a wildcard?

paola · June 19, 2014 6:59AM

You could use Search/Replace operation block to replace "?" with another symbol that is not found in the text.

mattyh · June 19, 2014 7:14AM

Thanks Paola

Welcome!

Categories

Ideas Parade

Tagged