I have list of investor name which are not same like "investor group" var. I want to create a variable like investor group from var investor_name. Please suggest me how to do it.
| Investor_name | Investor_group |
| Blue Ocean | Blue Ocean Partners |
| Blue Ocean Partners | Blue Ocean Partners |
| Blue Ocean Partners LLC | Blue Ocean Partners |
| Breakthrough Energy | Breakthrough Energy |
| Deutsche Bank | Deutsche Bank |
| Goldman | Goldman Sachs |
| Goldman Sachs | Goldman Sachs |
| Goldman Sachs, Inc | Goldman Sachs |
| Google Ventures | |
| J.P. Morgan | JP Morgan |
| JP Morgan | JP Morgan |
| JP Morgan Chase | JP Morgan |
| Kleiner Perkins | Kleiner Perkins |
| Kleiner Perkins Caufield & Byers | Kleiner Perkins |
| Biomet Orthopedics, LLC | Biomet |
| Biomet Spine, LLC | Biomet |
| Biomet Trauma, LLC | Biomet |
| Biomet Sports Medicine, LLC | Biomet |
| BIomet 3i, LLC | Biomet |
| Biomet Microfixation, LLC | Biomet |
| Biomet Biologics, LLC | Biomet |
| Davol Inc. | C. R. Bard |
| Bard Peripheral Vascular, Inc. | C. R. Bard |
| C. R. Bard, Inc. & Subsidiaries | C. R. Bard |
| Bard Access Systems, Inc. | C. R. Bard |
| DePuy Synthes Products LLC | DePuy |
| DePuy Mitek LLC | DePuy |
| DePuy Orthopaedics Inc. | DePuy |
| Synthes USA Products LLC | DePuy |
| DePuy Spine, LLC | DePuy |
0 Response to group string var with random names
Post a Comment