codingchemist
New Member
- Joined
- Jun 29, 2018
- Messages
- 2
I have two arrays. Array A has a list of multiple terms in a column such as this:
<tbody>
</tbody>
Array B has a list of single terms such as this:
<tbody>
</tbody>
I want to map the terms from Array B onto Array A. So, I want Array A to look like, with the terms from Array B included in it.
<tbody>
</tbody>
Normally I would do an index match, but I need to find a partial match from Array A to Array B. Is there an easy way to do this?
Urinary Bladder Cancer|Bladder Tumors|Transitional Cell Carcinoma of the Bladder|Malignant Melanoma|Melanoma|Skin Cancer|Carcinoma, Non-Small-Cell Lung|Lung Cancer |
Platinum Sensitive Ovarian Cancer|Ovarian Cancer |
Gastric Cancer |
<tbody>
</tbody>
Array B has a list of single terms such as this:
Gastric Cancer |
Ovarian Cancer |
Bladder Cancer |
<tbody>
</tbody>
I want to map the terms from Array B onto Array A. So, I want Array A to look like, with the terms from Array B included in it.
Urinary Bladder Cancer|Bladder Tumors|Transitional Cell Carcinoma of the Bladder|Malignant Melanoma|Melanoma|Skin Cancer|Carcinoma, Non-Small-Cell Lung|Lung Cancer | Bladder Cancer |
Platinum Sensitive Ovarian Cancer|Ovarian Cancer | Ovarian Cancer |
Gastric Cancer | Gastric Cancer |
<tbody>
</tbody>
Normally I would do an index match, but I need to find a partial match from Array A to Array B. Is there an easy way to do this?