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!
Question
How to search a text field for given values and use them to join or merge tables.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 7843 replies
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.
