AFTER

AFTER(data,substring);

The AFTER(data, substring) function is used to return the part of a data string that appears after the first occurrence of the specified substring.

Examples:

  • The field name is "Postal Code and City" and the field value is '6000 Kolding':


Examples:

##AFTER("Postal Code and City", ' ')

This formula will return Kolding.

##AFTER("Postal Code and City", '6000')

This formula will return Kolding with a blank in front.

##AFTER("Postal Code and City", '6000')

This formula will return Kolding.