|
glog.sqlServlet.quotableCharacters
=<set of quotable characters>
|
20C
|
Controls SQL Execution Interface exports to Excel.
If any character in the cell matches one in the set, the cell value will be delimited by the quote delimiter. Note that to match ASCII characters, use a backslash followed by a three-digit ASCII code. E.g., for space: \\032, for CR: \\013, for LF: \\010. This defaults to \\010\\013, ensuring that any newlines are quoted but not other whitespace. (Note two backslashes are used to specify one.) Default: \010\013.
|
|
glog.sqlServlet.quoteDelimiter
=<quotable string delimiter>
|
20C
|
Controls SQL Execution Interface exports to Excel.
This delimits a cell whose contents contain a quotable character (see glog.sqlServlet.quotableCharacters). Note that a double-quote is a reserved and must be entered as \". Defaults to a double-quote for compatibility with Excel when opening from a browser or Windows Explorer. Note that Excel has a known issue where opening export files with File|Open or Data|Text to Columns will not respect newlines within delimited quotes. Default: ".
|
