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.

  • Tooltips that include an argument and short descriptive name are provided for each tab item.