Contains filter only searches for words

Need help
22

Actually, yes. Not sure why I hadn’t thought of it before. It won’t work at the scale of a large forum, but should do for smaller searches.

Data …

StringThing

Text
List of Words

WordThing

Text
List of Strings

  1. Take your input with your words in it, and split them out using an “Extract with a Regex” “[^”]+"|([^)]+)|[^"\s()]+ so this produces a list of words

  2. Save your “string” of words. Run an API workflow on the list from step 1. Pass in the “string” thing and the text.

  3. If the “word” doesn’t already exist in WordThing, then Create it, and add it to the List of Words on String

  4. If the “word” does exist in WordThing, then update the Word to add the string to the list, and add it to the List of Words on String as well.

This then gives you a list of words. You can use this in a search box, and then use the output of the search box to show that Word’s list of Strings.

And there you go. Partial Word Search on the beginning of words only. So Alb, Albe, Alber etc

If you were really clever, you could then run API workflows on each word (you will need to limit the number of letters in a word I would think) and pull back all the internal combinations too. So “bert” to match with Albert.

But at that level of complexity your might be better off spinning up an instance of ElasticSearch and using the API connector.

Will put in as an Example in BuildingOnBubble shortly.

2 Likes