Flag a word only if within x words of another word?

[BigDataGeek]

Hey All,

I have a workflow that is doing as needed, but we need a new functionality I'm not sure the best way to approach. 

• Right now, this workflow finds words in a list that match the input and then adds some HTML around the word(s) identified which we use to publish. 
• Next addition, I need to find words when they are near another word.  
  • I've updated the list to add two columns [near] and [distance], where [near] is the word it would look for around the keyword and [distance] is the number of words to look for before or after the keyword.
  • What it should do is find the word as normal, but if there is information in columns 'distance' and 'near', only flag if it meets the criteria.
  • If 'near' and 'distance' are blank, it would return the results as normal.

[Yoshiro_Fujimori · Accepted solution]

Hi @BigDataGeek ,

I focused on the word distance logic. I hope this helps.

Workflow

Output