(string find_text, string within_text)
Finds one text value within another (case-sensitive) and return the number of the starting
position of the first text string from the first character of the second text string.
Example: FIND(bra, abracadabra) returns (2).
find_text: Required. The text you want to find.
(string find_text, string within_text, int start_num)
Finds one text value within another (case-sensitive) and return the number of the starting
position of the first text string from the first character of the second text string.
Example: FIND(bra, abracadabra,3) returns (9).
find_text: Required. The text you want to find.
Example 1
Find the position of the Space character:
find(" ",&SelltoContact)
Example 2
Use FIND and LEFT to extract First Name from string:
left(&SelltoContact,find(" ",&SelltoContact)-1)
Example 3
Use FIND and LEN and RIGHT to extract Last Name from string:
right(&SelltoContact,len(&SelltoContact)-find(" ",&SelltoContact))
Example 4
Find the position of the Space character, between the names (starting from position 5):
find(" ",&SelltoContact,5)
Comments
Please sign in to leave a comment.