I have a spreadsheet with a list of company names, and an RSS with a text field that may contain one or more of the company names (along with other text). How can I use FME to search the RSS text field and match it to my company names? So far I have tried the InlineQuerier with an SQL JOIN and LIKE statement, but I'm not getting as many matches as I expect and only one company name matching when there may be >1. I want my output to contain a field that lists all the company names found in the RSS text field. Any suggestions or alternative workflows would be greatly appreciated!
How to search a text field for given values and use them to join or merge tables.
Userlevel 2
+17
- Contributor
- 7538 replies
-
19 September 2017
Hi @FMELizard, I would try this.
- Aggregator: Concatenate all company names separating with | (pipe).
- FeatureMerger: Merge the pipe-concatenated company names to the RSS_text feature unconditionally.
- StringSearcher: Find every substring that match a company name.
Regex
\b(@Value(COMPANY_NAME))\bTheoretically this should work, but I don't know if there is a limitation on the maximum number of strings specified with pipe-separated format.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.