Reference a Field with Special Characters
The Sumo Logic query language allows alphanumeric characters and underscores for field names, with the exception of starting a field name with a number. In cases where a field name contains special characters, you need to escape the field name by using the following syntax when calling the field in the query:
| keyvalue regex " ([A-Z_-]+?)='([^']+?)'" keys "TYPE", "CHANNEL", "DOCUMENT-URI"
| count by %"document-uri"
You can create a field with the
You don't need to escape field names that:
- have characters matching
- don't begin with a number or
- don't have more than one
Escaping field names with the syntax
%\<field_nam\>" is a safe practice when using special characters. You will need to escape any quote characters
" with a backslash
\ to use them in the field name when referencing a field with special characters.