TrimFunction
New Member
- Joined
- Jan 9, 2018
- Messages
- 18
background: I'm building a reference file of branded product names. My aim is to have a clean list that can be used to search through a free text fields from a CRM system.
I want to find brand-names, but do not want common words like "account" or "management", since that will return almost every entry. the list of terms i search for is usually about 300+, using {=INDEX($B$2:$B$300,MATCH(1,COUNTIF(I3,"*"&$A$2:$A$300&"*"),0))}.
Question: What is the best way to "scrub" out the brand names from free text?
my current process is start with the list:
<colgroup><col></colgroup><tbody>
</tbody>
I want to find brand-names, but do not want common words like "account" or "management", since that will return almost every entry. the list of terms i search for is usually about 300+, using {=INDEX($B$2:$B$300,MATCH(1,COUNTIF(I3,"*"&$A$2:$A$300&"*"),0))}.
Question: What is the best way to "scrub" out the brand names from free text?
my current process is start with the list:
Original Product Name | ||||||||||||||||||||||||||||||||
Accounts Receivable, JD Edwards EnterpriseOne | ||||||||||||||||||||||||||||||||
IBM Kenexa Employee Assessments | ||||||||||||||||||||||||||||||||
Catalog Management, PeopleSoft | ||||||||||||||||||||||||||||||||
SAP Ariba Invoice Management Text to columns, sort, then manually read through to determine which are "brand" names: Column A Column B
<colgroup><col><col></colgroup><tbody> </tbody> I've been using countifs to determine how frequent the word occurs and LEN to quickly go through short words, but this is not efficient. Is there a better way to do this? | ||||||||||||||||||||||||||||||||
<colgroup><col></colgroup><tbody>
</tbody>