7.1
2013-09-23

POS

Syntax

POS(Text, String to find, Start position)

Description

Returns the character position of a searched string in text. Returns 0 if not found.

Example

POS("Personalized Printing", " ", 1) => 13

Parameter description

Text

Any text expression or data field containing a text.

String to find

String to search for.

Start position

Position to start search from.

This function allows you to search for certain character in the value of a database field. The result will be the position of the character you are searching for.