IndexOf

The ‘IndexOf()’ function searches for specific instances of characters in a source text. It searches from the indicated beginning of the text and displays the first search result found. If no instance 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

IndexOf(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
  • [%=IndexOf(email, "@", 1)] returns a value of 5 for the email address ‘info@inxmail.de’, for example. This string function outputs the index where the @ character is found.
  • If you would like to extract the substring before the @ character from the entries in the ‘email’ table column, enter the following function:
  • [%=Substring(email, 1, IndexOf(email, "@", 1)-1)] returns ‘mike.miller’, for example.
  • You can also include string functions in a condition, for example, you can specify that the phrase "Caution! Space character found!" appears if a space character is found in an entry in the Postcode column.
  • [%=IIf(IndexOf(Name, " ", 1)>0, “Caution! Space character found!", “No errors found!")] returns ‘Caution! Space character found!’ if the condition applies. type. Otherwise ‘No errors found’.