M
Michael
Is there a way to search a field for keywords, and then
populate the new field based on that search?
I have sales that I want to categorize by product type.
I need a new field called "ProductType", and then
populated based on "ProductDescription".
For instance, if "ProductDescription" = Forks or Spoons,
the new field should automatically say "silverware". If
it was pots or pans, it should say "cookware".
populate the new field based on that search?
I have sales that I want to categorize by product type.
I need a new field called "ProductType", and then
populated based on "ProductDescription".
For instance, if "ProductDescription" = Forks or Spoons,
the new field should automatically say "silverware". If
it was pots or pans, it should say "cookware".