String Tab
Use the String tab to perform string manipulation and queries.
String Tab options
Button |
Syntax |
Definition |
---|---|---|
|
strlen() |
Returns the number of characters in the string in brackets. |
|
substr(,,) |
Retrieve a sub-string of the string in the 1st argument, of the length indicated in the 3rd argument and starting at the offset indicated in the 2nd argument. Errors are issued for out of range operation, and a NULL string is returned. SUBSTR(“HELLO”,5,1) results in “” (past end of string) SUBSTR(“HELLO”,-1,3) results in “” (invalid starting offset) SUBSTR(“HELLO”,0,-1) results in “” (invalid number of characters) |
|
findstr(,) |
If the 2nd string is found inside the 1st string, this functions returns the offset of the 1st character of the 1st occurrence of the 2nd string inside the 1st string. This is a case insensitive function. Errors are issued for erroneous operation, and a NULL string is returned. |
|
catstr(str1,str2) |
Concatenate 2 strings. |
|
strcmp(str1,str2) |
Case sensitive comparison of two strings. Returns 0 if the 2 strings are identical. Otherwise return the difference of the ASCII value of the 1st unmatched characters in the 2 strings. |
|
strncmp(str1,str2,N) |
Case sensitive partial comparison of two strings. Returns 0 if the 2 strings up to the Nth character are identical. Otherwise return the difference of the ASCII value of the 1st unmatched characters in the 2 strings. |
|
stricmp(str1,str2) | Case insensitive comparison of two strings. The comparison is performed between the lower case equivalents of the two strings. Returns 0 if the 2 strings are identical. Otherwise return the difference of the ASCII value of the 1st unmatched characters in the 2 strings. |
|
strnicmp(str1,str2,N) | Case insensitive comparison of two strings. The comparison is performed between the lower case equivalents of the two strings. Returns 0 if the 2 strings up to the Nth character are identical. Otherwise return the difference of the ASCII value of the 1st unmatched characters in the 2 strings. |
Application Notes
The String tab will not be visible unless your database contains a string channel.
Got a question? Visit the Seequent forums or Seequent support
© 2023 Seequent, The Bentley Subsurface Company
Privacy | Terms of Use