indexof

Syntax:

Value Integer  indexof(String str, String substr)

Description:

Returns the position of the first occurence of substr in str or -1 if it is not present.

Examples:

($c1:$c5) = indexof($a, $b)
Before:
AB C
1Hello WorldWo
2My Name is AlexName
3ABCabcc
44.567
5XSheetsheet
616
After:
AB C
1Hello WorldWo6
2My Name is AlexName3
3ABCabcc5
44.567-1
5XSheetsheet-1
616
($d1:$d10) = indexof($b, "2")