[ https://issues.jboss.org/browse/TEIIDDES-2394?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2394: ---------------------------------------- * NO ROW DELIMITER indicates that fixed parsing should not assume the presence of newline row delimiters. * ROW DELIMITER sets the row delimiter / new line to an alternate character. Defaults to the new line character - with built in handling for treating carriage return new line as a single character. If ROW DELIMITER is specified, carriage return will be given no special treatment. * DELIMITER sets the field delimiter character to use. Defaults to ','. * QUOTE sets the quote, or qualifier, character used to wrap field values. Defaults to '"'. * ESCAPE sets the escape character to use if no quoting character is in use. This is used in situations where the delimiter or new line characters are escaped with a preceding character, e.g. \, {code} TEXTTABLE(expression [SELECTOR string] COLUMNS <COLUMN>, ... [NO ROW DELIMITER | ROW DELIMITER char] [DELIMITER char] [(QUOTE|ESCAPE) char] [HEADER [integer]] [SKIP integer] [NO TRIM]) AS name {code} Where <COLUMN> {code} COLUMN := name (FOR ORDINALITY | datatype [WIDTH integer [NO TRIM]] [SELECTOR string integer]) {code} -- This message was sent by Atlassian JIRA (v6.3.11#6341)