Functions
String Functions
- CASE
- CHOOSE
- COMPARE
- CONCAT
- CONCATENATE
- DATESTR
- ENDSWITH
- FORMAT
- FROMBASE64
- INSTR
- JOIN
- JSELECTTOKEN
- LEFT
- LEN
- LENGTH
- LOWER
- LTRIM
- MD5HASH
- MID
- NEWLINE
- OBFUSCATE
- PADLEFT
- PADRIGHT
- PROPER
- PROPERTY
- REPLACE
- REPLACEREGEX
- RIGHT
- RTFTOPLAINTEXT
- RTRIM
- SEARCH
- SHA1HASH
- SPLIT
- STARTSWITH
- STR
- SUBSTR
- TOARRAYSTRING
- TOBASE64
- TOBYTEARRYASCII
- TOBYTEARRAYUNICODE
- TOBYTEARRAYUTF8
- TRIM
- UPPER
SEARCH
Searches the first position of a string in another string, will return the location of a string in another string or 0 if it cannot be found.
Syntax
int SEARCH(string searchText, string value)
int SEARCH(string searchText, string value, int start)
Input
| Object | Data Type | Description |
|---|---|---|
| value | String | The string to look in. |
| searchText | String | The string to find. |
| start | Integer | The position to start from (1 is the first position). |
Example
SEARCH("bet","in-between")
Will return "4" as "bet" begins at the fourth position within the string.
SEARCH("Simego","Company: Simego",8 )
WIll return "2" as "Simego" starts at the second position after the specified start location.