Text Query Syntax

Function	Comment
`CONCATENATE(a1,a2,..,aN)`	This function can concatenate an arbitrary number of strings. Arguments can be row names or static values. For example: `CONCATENATE("Card Number: ",Card Number)` Returns string.
`FORMAT(row_name,format)`	This function formats values defined in the row, in the format used by PowerShell (.Net). `FORMAT(Number,"R")` Returns string.
`REGEXSUB(row_name,pattern,replacement)`	Regex replacement. `REGEXSUB(User Name,"^(.+), (.+)","$2 $1")` Returns string.
`REGEX(row_name,pattern)`	Regex matching. Positive matching. `REGEX(email,".+@gmail\.com$")` Returns Boolean.
`NOT_REGEX(row_name,pattern)`	Regex matching, negative matching. `NOT_REGEX(email,".+@gmail\.com$")` Returns Boolean.
`LIKE(row_name,pattern)`	LIKE matching. Positive matching. `LIKE(email,"%@gmail.com")` Returns Boolean.
`IF(condition,t_value,f_value)`	This function will perform and equality check, where “condition” will appear as an equals statement, like: “State=Active”. Where “State” is a column name, and “Active” is a string. “t_value” and “f_value” are the values returned when the condition is true or false respectively. `IF(State="Active","Enabled","Disabled")` Returns string.
`UNIQUE(value)`	This function will ensure that only unique values will appear for this entity type. For instance, “`UNIQUE(Employee ID)`" applied to the '`int_short_name`' will ensure no two entities have the same 'int_short_name'.Returns the same datatype has 'value' in the function example, but will ensure uniqueness on that value.

Text Query Syntax

When connecting systems and writing reports, in some cases we will need to use a function to get the linking or result that we require. This table summarizes the options available within Gathid.