Name |
Brief |
Example |
asc |
Returns the ASCII value of the uppercase character in parentheses. |
Example |
between |
Extracts a substring using begin and end strings or characters. |
Example |
Char |
Return the character specified by the code number. |
Example |
Code |
Return a numeric code for the first character in input string. |
Example |
Compare |
Compare str1 with str2, identical will return 1. |
Example |
CompareNoCase |
Compare str with str2, returns 0 if identical, negative if str$ is less than str2$ in the alphabetical order, positive if str$ is greater than str2$.. |
Example |
EnvVar |
Returns the string value stored in the windows environment variable. |
Example |
Exact |
Return TRUE if both strings are an exact match (case and length). |
Example |
Find |
Finds a string within another string. Case sensitive. No wildcards. |
Example |
FindOneOf |
Finds characters of a string within another string and returns the index of the first found character. Case sensitive. No wildcards. |
Example |
Format |
Convert double to string with LabTalk formatting option. Superseded in 9.1 by Text function. |
Examples |
GetAt |
Returns a single character specified by an index number. |
Examples |
GetFileExt |
Get the file extension from the full path. |
Examples |
GetFileName |
Get the file name from the full path. |
Examples |
GetFilePath |
Get the path from the full path. |
Examples |
GetLength |
Get the length of a string. |
Examples |
GetToken |
Returns the nth token where a token is separated by the delimiter specified by chDelimiter. |
Examples |
IsEmpty |
Determine whether worksheet cell is empty or contains data/missing values. |
Example |
IsFile |
Test whether the string is a valid full path file name |
Example |
IsFormula |
Determine whether worksheet cell contains cell formula. |
Example |
IsPath |
Test whether the string is a valid file path. |
Example |
Left |
Returns the leftmost n characters from the string. |
Example |
Len |
Returns the number of characters of a string str. |
Example |
Lower |
Converts the string to lowercase. |
Example |
MakeCSV |
This function converts a string which has an identical delimiter into CSV format. |
Example |
Match |
Compares the string find$ with another string within$ to see whether their contents match with each other. |
Example |
MatchBegin |
Finds a string pattern within a string. Supports * and ? wildcard characters. Optionally, case-sensitive. |
Example |
MatchEnd |
Finds a string pattern within a string (str1). Supports * and ? wildcard characters. Optionally, case-sensitive. |
Example |
Mid |
Returns a specific number of characters n2 from the string str, starting at the specific position n1. If n2 is not specified, returns everything from n1 to the end of the string. |
Example |
NumberValue |
Converts a string value to a numeric, with options for specifying decimal and separator characters to be used in interpreting the string. |
Example |
Replace |
Replace n2 characters in string1 starting at n1th position with string2. |
Example |
Right |
Returns the rightmost n characters from the string. |
Example |
Search |
Finds a string within another string. Not case sensitive. No wildcards. See MatchBegin. |
Example |
SpanExcluding |
Searches a string for the first occurrence of any character in the specified set string. SpanExcluding extracts and returns all characters preceding the first occurrence of a character from the specified set string. |
Example |
SpanIncluding |
Extracts characters from a string, starting with the first character in the specified set string |
Example |
Substitute |
Substitute string3 with string2 when found in string1. |
Example |
Text |
Convert double to string with LabTalk formatting option. |
Examples |
TextJoin |
Join several texts using specified delimiter. |
Example |
Token |
Get the Nth token using specified delimiter from a string. |
Example |
Trim |
Removes spaces from string. |
Example |
Upper |
Converts the string to uppercase. |
Example |
Value |
Converts the string number to double. |
Example |