The case-sensitive hassuffix_cs string operator
Learn how to use the hassuffix_cs operator to filter data with a case-sensitive suffix string.
Filters a record set for data with a case-insensitive ending string. hassuffix_cs returns true if there is a term inside the filtered string column ending with the specified string expression.
Performance tips
Syntax
T | where column hassuffix_cs ( expression )
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| T | string | ✔️ | The tabular input whose records are to be filtered. |
| column | string | ✔️ | The column by which to filter. |
| expression | scalar | ✔️ | The scalar or literal expression for which to search. |
Returns
Rows in T for which the predicate is true.
Examples
StormEvents
| summarize event_count=count() by State
| where State hassuffix_cs "AS"
| where event_count > 2000
| project State, event_count
Output
| State | event_count |
|---|---|
| TEXAS | 4701 |
| KANSAS | 3166 |
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.