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
Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.