---
title: "LAST"
description: "LAST"
keywords: "LAST"
url: "https://myrapidi.com/wiki/last"
locale: "en"
published: "2009-05-15T09:26:42Z"
modified: "2012-11-08T07:27:04Z"
---

# 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.