Extracting common names

Hi,
I have a list of company names and I want to extract the common names.
For example, ABC Company (A), ABC Company (B), ABC Company ©.
I would like my dropdown to show “ABC Company” instead. Is there a solution to this?

0 3 133
3 REPLIES 3

Steve
Platinum 4
Platinum 4

Not easily. I imagine you’d have to add a (possibly virtual) column that computes each row’s common name, then use that column’s values to populate the dropdown menu.

How do you compute each row’s common name in a virtual column?

That’s entirely up to you. It depends on how you determine what constitutes a “common name”. Based on the examples you provided, it appears the common part occurs before the parenthesized part. To get the part before the parenthesized part:

ANY(SPLIT([column], " ("))

See also:


Top Labels in this Space