LAST

LAST(data, substring);

Using this function your program will return the string after the last occurrence according to what you specify.

 

Example:

If Source Data Base has an Address Field including both street and number, you can use the Formula "LAST".


Source value: Robinson South Street 3345
LAST(Address, ' ');
Returns the value = 3345.

 

The Formula finds the last existence of ' ' in a field and returns the value after that.

Source value: I am so very tired of integrating databases using custom made programming.
LAST(Comment, ' ');
Returns the value = programming.