String manipulation

CONCAT – Concatenate (join) separate strings

161 views June 1, 2018 February 10, 2019 admin 0

Overview

This Custom Field concatenates (joins) separate strings into a single string.

Syntax

CONCAT(Argument1,Argument2,Argument2)

CONCAT(FIELDSTR(Description1), text, FIELDSTR(Description2))

Element Description
Argument1 A string, e.g. the contents of a specified field.
Argument2 A second string, e.g. freeform text.
Argument 3
A third string, e.g. the contents of a specified field.

Example

A clothing manufacturer has jumpers and shirts available in red and green and jeans in blue and black.

Product Name Product Colour
Jumper Red
Jumper Green
Shirt Red
Shirt Green
Jeans Blue
Jeans Black

CONCAT(FIELDSTR(‘ProductColour’), FIELDSTR(‘ProductName’)) will return

Red Jumper

Green Jumper

Red Shirt

Green Shirt

Blue Jeans

Black Jeans

CONCAT(FIELDSTR(‘ProductName’)‘, ‘available in ‘, FIELDSTR(‘Product Colour’)) will return

Jumper available in Red

Jumper available in Green

Shirt available in Red

Shirt available in Green

Jeans available in Blue

Jeans available in Black

See also

UPPER

LOWER

REGEX

STRIPWHITESPACE

TITLECASE

SENTENCECASE

Was this helpful?