Share via

FIND Function [Visio 2003 SDK Documentation]

  • Article

Finds one text string contained within another text string, and returns the starting position of the text string you are seeking relative to its position in the text string that contains it.

FIND (find_text, within_text ,[start_num], [ignore_case])

find_text The text string you want to find.

within_text The text string that contains the text you want to find.

start_num Optional. The character at which to start the search. The first character in within_text is 1. If start_num is missing, it is assumed to be 1.

ignore_case Optional. By default, the FIND function is case-sensitive. If you want the FIND function to ignore case, set this argument to TRUE.

Remarks

If multiple matches are found, the FIND function returns the starting position of the first match in the string. The find_text argument does not consider any characters to be wildcards.

If find_text:

  • Is empty "", FIND matches the first character in the search string (that is, the character numbered start_num or 1).
  • Does not appear in within_text, it returns the #VALUE! error value.

If start_num:

  • Is not greater than zero (0), it returns the #VALUE! error value.
  • Is greater than the length of within_text, it returns the #VALUE! error value.

Example

FIND ("2003","January 1, 2003")

Returns 12.