Correlates the character positions in paired strings
CHARRELA(<cSearchFor1>,<cString1>,<cSearchFor2>, <cString2>) --> nPosition
<cSearchFor1> Designates the character that is searched for in <cString1>.
<cString1> Designates the character string to search with <cSearchFor1>.
<cSearchFor2> Designates the character that is searched for in <cString2>. <cString2> Designates the character string to search with <cSearchFor2>.
CHARRELA() returns the positions where <cSearchFor1> and <cSearchFor2> occur in the corresponding character strings.
This function builds a relationship (CHAR RELAtion) between two character strings. It determines the positions where the characters in <cSearchFor1> appear in <cString1> and where the characters in <cSearchFor2> appear in <cString2>.
. The function returns a value of 0 if no relationship is found.
Search for the first position in which a "b" appears in the first string and a "1" appears in the second: ? CHARRELA("b", "b b b b", "1", "bbb11111") // 5