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.