MATCH multiple values

[dafnis14]

Hi,

Is there a way to match a string to more then one string (AND condition)?

For example:

I have a field with multiple flight classes. For example:

"Low Economy, High Business, First Class".

If the field has the values "Economy" and "Business", it would be linked to a description field: "Combined Economy/Business".

How can I apply such a matching condition?

Thanks!

[asinha1991]

if sequence of classes in the string remains same, you can use something like this
=if(WildMatch('Low Economy, High Business, First Class','*Economy*Business*'),'Combined Business/Economy',0)

if not , you can split the value using subfield and then re concatenate in a specified order using concat( can help here if you want), then apply wildmatch.

[dafnis14]

Hi Asinha,

Thanks for your reply!

The  problem is that the sequence is not the same.

Besides, we are talking about  fields with different strings: both source and target. So the script has to be generic..

My current  solution is to prepare  beforehand he  possible combinations of strings for the the wild match..

But I hope there is a better one 🙂