String Functions

Use the String functions located on the Functions»String palette to concatenate two or more strings, extract a subset of strings from a string, convert data into strings, and format a string for use in a word processing or spreadsheet application.

Click the icons for function descriptions.

String Length Concatenate Strings String Subset To Upper Case To Lower Case Additional String Functions Replace Substring Search and Replace String Match Pattern Format Date/Time String String/Number Conversion Scan From String Format Into String Spreadsheet String To Array Array To Spreadsheet String String/Array/Path Conversion String Constant Empty String Constant Carriage Return Constant Line Feed Constant End of Line Constant Tab Constant

Array to Spreadsheet String Scan From String
Carriage Return Search and Replace String
Concatenate Strings Spreadsheet String To Array
End of Line String Constant
Empty String String Length
Format Date/Time String String Subset
Format Into String Tab
Line Feed To Lower Case
Match Pattern To Upper Case
Replace Substring

Subpalettes

Additional String Functions String/Array/Path Conversion Functions
String/Number Conversion Functions