LastIndexOf

The ‘LastIndexOf()’ function searches for specific instances of characters in a source text. It searches for the last instance of a character and displays this as a search result. If no character is found, then the value 0 is returned.

Note: In the source text, the first character is in position 1.

Can be used in: mailing text, actions

Syntax

LastIndexOf(SourceText, SearchText, SearchStart)

Result

Indicates the position of a specific character string, type: integer

Parameter:

  • Source text
  • Search text
  • Search start

 

  • String to be searched in, Type: Text
  • String, to be searched for in the source text, Type: Text
  • The position the search should start, Type: Integer

[%=LastIndexOf(email, ".", Length(email))] returns a value of 18 for the email address ‘good.info@inxmail.de’.

You would like to separate and display the substring after the last full stop from entries in the ‘email’ table column. Specify the following string function:

[%=Substring(email, LastIndexOf(email, ".", Length(email))+1, Length(email), “Error")] returns ‘de’, for example.