Apr 23 2021 05:25 AM
I am trying to fetch the machine list which does not contain letter " l " in 8th position.
can i use Kusto regex to achieve this. I only see matches regex command.
Apr 23 2021 06:35 AM
Apr 23 2021 07:55 AM
Can you post the complete query? We will be able to help.
Have you tried using the "| where not" xxxxxxx feature?
Apr 23 2021 08:18 AM
@deepak198486 There is the indexof_regex command (indexof_regex() - Azure Data Explorer | Microsoft Docs) that could work
Apr 23 2021 08:20 AM
Apr 23 2021 09:17 AM
Apr 23 2021 09:54 AM
@deepak198486 You can also try just plain indexof() to see if it is faster than using the regex.
| indexof(VM,"l",8,1)==-1
Apr 25 2021 11:42 PM
Apr 26 2021 04:01 AM
Apr 26 2021 04:22 AM