Scalar Operators

String operators

Axiom processing language provides you with different query operators for searching string data types.

Below are the list of string operators we support on Axiom processing langauage.

Note:

The following abbreviations are used in the table below:

  • RHS = right hand side of the expression.
  • LHS = left hand side of the expression.

Operators with an _cs suffix are case sensitive

The table below shows the list of string operators supported by Axiom processing language:

OperatorDescriptionCase-SensitiveExample
==EqualsYes"aBc" == "aBc"
!=Not equalsYes"abc" != "ABC"
=~EqualsNo"abc" =~ "ABC"
!~Not equalsNo"aBc" !~ "xyz"
containsRHS occurs as a subsequence of LHSNoparentSpanId contains Span
!containsRHS doesn't occur in LHSNoparentSpanId !contains abc
contains_csRHS occurs as a subsequence of LHSYesparentSpanId contains_cs "Id"
!contains_csRHS doesn't occur in LHSYesparentSpanId !contains_cs "Id"
startswithRHS is an initial subsequence of LHSNoparentSpanId startswith parent
!startswithRHS isn't an initial subsequence of LHSNoparentSpanId !startswith "Id"
startswith_csRHS is an initial subsequence of LHSYesparentSpanId startswith_cs "parent"
!startswith_csRHS isn't an initial subsequence of LHSYesparentSpanId !startswith_cs "parent"
endswithRHS is a closing subsequence of LHSNoparentSpanId endswith "Id"
!endswithRHS isn't a closing subsequence of LHSNoparentSpanId !endswith Span
endswith_csRHS is a closing subsequence of LHSYesparentSpanId endswith_cs Id
!endswith_csRHS isn't a closing subsequence of LHSYesparentSpanId !endswith_cs Span
inEquals to one of the elementsYesabc in ("123", "345", "abc")
!inNot equals to any of the elementsYes"bca" !in ("123", "345", "abc")
in~Equals to one of the elementsNo"abc" in~ ("123", "345", "ABC")
!in~Not equals to any of the elementsNo"bca" !in~ ("123", "345", "ABC")
!matches regexLHS doesn't contain a match for RHSYesparentSpanId !matches regex g.*r

Performance tips

For better performance, when there are two operators that do the same task, use the case-sensitive one.

For example:

  • instead of =~, use ==
  • instead of in~, use in
  • instead of contains, use contains_cs