Category Archives: Formulas

String matching

The basic comparison if a field contains a value is very limited, regular expressions can be like magic if you know how to use it.

  • contains
  • starts with
  • ends with
  • exact match
      or
  • does not contain
  • contains multiple
      or
  • if a string starts with 2 numbers and has an underscore after that