SUBSTRING

Creates a new string starting from a fixed number of characters into the original string.

Syntax: SUBSTRING(expr FROM startPos FOR length)

Syntax description

expr is any expression that evaluates to a character string.

startPos is any positive integer that represents the number of characters from the start of the left side of the string where the result is to begin.

Steps: Go to Criterial – Select the Column – Right Click – Select Edit Formula – Click on Insert function – click on String folder and select Substring

Example: SUBSTRING("Date (Common)"."Month Name" FROM 1 FOR 3)