AFTER(, );

Using this function, the string after the specified substring will be returned.

Example

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

##AFTER("Postal Code and City", ' ');
Returns 'Kolding'.

 

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

Returns ' Kolding' (with a blank in front).

 

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

Returns 'Kolding'.