I have used the standard Excel * as a text wildcard in a formula but it does not work. Is there a different wildcard in Omniscope for any number of characters?
I have searched the help topics and can't find an answer to this.
Could you provide a little more context/detail on what situation/problem you are trying to solve using a wildcard, and the equivalent Excel expression?
Thanks for getting back to me. What I mean is the following example:
I have 3 fields called 'Behavioural: Conversion', 'Behavioural: Buzz' & 'Competitive:Spend'.
I am trying to create a formula which populates a new field where the metric starts with 'Behavioural'. Therefore I am trying to do an IF statement update where the metric is 'Behavioural*' and where the star is any number of characters following the word behavioural.
The star (*) is the any number of characters wildcard in excel.
As far as I'm aware, you can't do this in Excel. IF does not support wildcards. Some functions do (like COUNTIF), but in any case, Omniscope does not support these.
You can achieve the desired effect using SEARCH as the first clause of your IF statement:
http://www.visokio.com/functions-guide#SEARCH
E.g. IF( SEARCH("Beh*", [Metrics], 1)=1, [Metrics], "" )
The easiest way to achieve the desired result here is to use the LEFT function to compare then leftmost n characters with a desired string (in this case, "Beh") i.e.