Using prxmatch with multiple terms

Reply
Occasional Contributor
Posts: 11

Using prxmatch with multiple terms

[ Edited ]

I need to do a word search on a text field.  While I know how to search for multiple words using the Prxmatch function, I am not sure how I can search words such as "fire suppression", "Young men", and etc, i.e., a simple phrase that has two words or more.  If I were to split the phrase into two separate words, like "fire" and "suppression", then I will get many wrong matches due to the word "fire".  The same is true for the words "Young" or "men".  Is there a way to combine these words and use it in the Prxmatch function?

 

Thanks.

PROC Star
Posts: 7,467

Re: Using Prematch

A nice example can be found at: https://support.google.com/a/answer/1371417?hl=en#Match-Word-or-Phrase-in-a-List

 

Art, CEO, AnalystFinder.com

 

Respected Advisor
Posts: 4,173

Re: Using prxmatch with multiple terms

@docctong

With RegEx you're not really searching for words but for strings/text patterns. A blank between two words is nothing else than another character so simply search for such strings, i.e. '/fire suppression|young men/i'

Ask a Question
Discussion stats
  • 2 replies
  • 167 views
  • 0 likes
  • 3 in conversation