Text Function Reference

Click Functions Text to view and insert available text functions. Text functions operate on text properties and are useful for formatting the results of text-related queries. These functions are available for every data provider except for raster, WFS, and WMS providers.

When you create an expression for geospatial features, you can use the following text functions:

Function	Definition	Syntax	Example
CONCAT	Joins multiple strings into one. CONCAT takes any number of arguments, which can be any property type except Geometry or Raster. The return value uses the String data type. Use `‘\n’` to insert a line break when you use standard styles. Use '\P' to insert a line break when you use enhanced styles. These parameters are case-sensitive. To include static text labels or spaces, surround them with single quotes. When you use `Concat` with a Boolean property, the operation generates 1/0 (not True/False) as a result.	`CONCAT(Property, Property, ...)`	`CONCAT(First_Name, ‘ ‘Last_Name,’\P’ ‘Address: ‘, Street_number, ‘ ‘, Street_name, ‘ ‘, Suffix)` This example produces a tooltip like this: John Smith Address: 123 Maple Street

Function

Definition

Syntax

Example

CONCAT

Joins multiple strings into one.

CONCAT takes any number of arguments, which can be any property type except Geometry or Raster. The return value uses the String data type.

Use ‘\n’ to insert a line break when you use standard styles. Use '\P' to insert a line break when you use enhanced styles. These parameters are case-sensitive.

To include static text labels or spaces, surround them with single quotes.

When you use Concat with a Boolean property, the operation generates 1/0 (not True/False) as a result.

CONCAT(Property, Property, ...)

CONCAT(First_Name, ‘ ‘Last_Name,’\P’ ‘Address: ‘, Street_number, ‘ ‘, Street_name, ‘ ‘, Suffix)

This example produces a tooltip like this:

John Smith

Address: 123 Maple Street

Text Function Reference

Related Reference