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?
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:
User | Count |
---|---|
42 | |
34 | |
26 | |
23 | |
15 |