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
|