3.5.7 Text

Note:
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