How to get a Combination of values

[TimOzirsky]

I have a field name Product Names that includes multiple product names A - Z in random order, for example A|J, B|O, O|A, A, O.
I want to create a field named HR solution with specific values for a specific set of the product names.

Product Names A or B should be HR Solution 1.
Product Names J or K should be HR Solution 2.
Product Names O should be HR Solution 3.

Possible values for HR Solution are any combination of 1,2 and 3. For example 1, or 2 or 3 or 1,2 or 1,3 or 2,3, etc.

Will someone please let me know a workflow to resolve this?

Thanks,
Tim

[Bren_Spill2 · Accepted solution]

@TimOzirsky - Find and replace works well here. See attached

[TOzirsky]

Thank you very much.
This gets me part way there.
How can I not have the Product Name in HR Solution for Product Names like C or C|D or A|G|H|O, etc.?

Thank you!  

[TimOzirsky]

I have a field name Product Names that includes multiple product names A - Z in random order, for example A|J, B|O, O|A, A, O, C, C|D, A|G|H|O.
I want to create a field named HR solution with specific values for a specific set of the product names.

Product Names A or B should be HR Solution 1.
Product Names J or K should be HR Solution 2.
Product Names O should be HR Solution 3.

Possible values for HR Solution are any combination of 1,2 and 3. For example 1, or 2 or 3 or 1,2 or 1,3 or 2,3, etc.

I don't want to have the Product Name in HR Solution for Product Names like C or C|D or A|G|H|O, etc.
I also don't want to repeat an HR Solution, for example, O|J|K should be HR Solution 3, 2, NOT 3,2,2.

Will someone please let me know a workflow to resolve this?

Thanks,
Tim