Building and Using Dashboards > Dashboard Function Reference > Tabular Functions > String to Table
String to Table
Returns a table whose cell values are specified by a string that uses specified row and column delimiters.
Arguments
The function has the following arguments:
*String: Text string to be converted into a table.
*Row Delimiter: Text string that specifies the delimiter by which the data for one row is separated (in String) from the data for the next row.
Note, if you specify a delimiter that consists of more than one character, those characters are treated as a sequence of delimiters and a new row is created when any one of them is encountered.
*Column Delimiter: Text string that specifies the delimiter by which the data for one cell in a row is separated (in String) from the data for the next cell in that row. If the table is to contain only one column, do not specify a value for Column Delimiter.
Note, if you specify a delimiter that consists of more than one character, those characters are treated as a sequence of delimiters and a new column is created when any one of them is encountered.
*Column Name Mode: Text string that specifies how the function should determine column names for the returned table. Specify one of the following:
*AUTO: Use the generated names col0, col1, col2, and so forth.
*STATIC: Use the names specified in Column Names.
*STRING: Use the values specified in the first row of String.
AUTO is the default setting; leaving this unset or set to a value other than AUTO, STATIC, or STRING defaults to AUTO.
*Column Names: Text string that specifies the column names to use in the returned table, if Column Name Mode is Static.
*Allow Empty Rows/Columns: Specifies whether or not empty cells will be created when empty tokens in the string are encountered. Setting this argument to "true" or "1" means empty cells will be created. For example, in a string that uses "," (comma) as a delimiter, a row represented by 1, , ,4 will result in a row with 1 in the first column followed by two empty cells, followed by 4. Setting this to "false", "0", or leaving it unset (the default) means that empty tokens will be ignored. In this case the "1, , ,4" example will create a row with 1 in the first column, followed by 4 in the second column, followed by two blank columns.
This function returns a table.
Copyright © 2013-2015 Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Use, reproduction, transfer, publication or disclosure is prohibited except as specifically provided for in your License Agreement with Software AG.