Find Last

Search for the last match inside text, where 0 is the first position. The function card returns -1 if no match is found.

Input

Field	Definition	Type	Required
look in	Text within which a search for a string is performed.	String	TRUE
look for	String for which a search is performed.	String	TRUE
right-most position	Right-most position in a string value, where `0` is the first position.	Number	FALSE

Output

Field Definition Type

position

Field	Definition	Type
position	Position of the last match found, where `0` is the first position. Returns `-1` if no match is found.	Number

Position of the last match found, where 0 is the first position.

Returns -1 if no match is found.

Number

Example

If the look in field contains Mississippi, and:

If look for contains ss and right-most position does not contain a value, then position returns 5 (the position of the second occurrence of ss).
If look for contains ss and right-most position contains 4, then position returns 2 (the search is only within Missi and stops at position 4).
If look for contains abc, then position returns -1 (not found).