Site icon TheWindowsUpdate.com

Tip of the Week: How to search multiple strings for certain keywords?

This post has been republished via RSS; it originally appeared at: Azure Data Explorer articles.

 

Whenever you look for a way to search for multiple strings with specific keywords, you can leverage the following code Sample 

let any_of_the_following = dynamic(['FLORIDA','NEW YORK','GEORGIA']);
let any_of_the_following_regex = strcat(@'(?i)', @'\b(', strcat_array(any_of_the_following, "|"), @')\b');
datatable(tweet:string)
[
    'We saw heavy rain in Florida',
    'This string does not contain any state.',
    'FloridaShould appear separately.',
    'NEW YORK is still popular destination among tourists',
]
| where tweet matches regex any_of_the_following_regex

Tweet

We saw heavy rain in Florida

NEW YORK is still popular destination among tourists

 

“Join the conversation on the Azure Data Explorer community”.

Exit mobile version