i have a filter that looks to see if a field contains both the strings "EUR" and "USD" (as in various pairs of currencies). however, some fields will also have "European" in the name (which doesnt refer to the currency EUR) along with the pair of currencies. so i may have European EUR/USD (works fine since its picking up EUR regardless) or European INR/USD (will fail since its picking up EUR in European to create EUR/INR as the output when it should be INR/USD, or INR/USD (which is fine since European isnt included to mess the filter up) or EUR/USD (which is fine regardless if european was included).
I want to avoid the unintended filtering due to European in the name.
The things i have thought of...
1) is there a way to see if a field contains "EUR" two times in a filter?
2) is there a way to include an if then into the filter (if string contains European do one thing but if not, do another)
3) changing the ordering of the filters may be a work around as i can put the EUR pairs last so it would see USD/INR first and filter that out before it looks for EUR/XXX.
4) possibly removing European from the field prior to the sort (but not sure how that works either)
I dont want to filter to find European first as i would have to create two separate massive workflows off of each of the true and false legs.
Thanks,
