Determines whether a particular substring is stored at the beginning of another string.
@Begins( string ; substring )
string
Text or text string. Any string.
substring
Text or text string. The string you want to search for at the beginning of string.
flag
Boolean.
This function is case-sensitive.
If the either parameter is a list, the function tests each element of the second parameter against each element of the first parameter and returns 1 if any match occurs.
@Begins("Hi There";"Hi")
@Begins("Hi There";"hi")
@If(@Begins(Topic;"All desks memo");"Junk Mail"; "Read this first")
@If(@Begins(Signature; "Luigi":"Florence":"Henri"); "Verify signature"; "Don't Verify Signature")