String manipulation

TRUNCATESTR – Remove last N characters from string

105 views June 1, 2018 July 26, 2018 admin 0

Overview

This Custom Field removes the last N characters from a string, where N is a defined integer.

Syntax

TRUNCATESTR(N)

Element
Description
N The number of characters to be removed from the end of the string.

Examples

TRUNCATESTR(2)

String TRUNCATESTR(2)
Ford Motor Company Ford Motor Compa
Toyota Toyo

TRUNCATESTR(2)

String TRUNCATESTR(4)
Ford Motor Company Ford Motor Com
Toyota To

See also

PARTSTR

LEFTSTR

RIGHTSTR

Was this helpful?