[JBoss JIRA] (TEIIDDES-2389) Add ui support for whole texttable no trim
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2389?page=com.atlassian.jira.plu... ]
Barry LaFond edited comment on TEIIDDES-2389 at 3/10/15 11:16 AM:
------------------------------------------------------------------
Basically add a "NO TRIM" check-box to the TEXT TABLE options dialog. This was added in Teiid 8.8, so only need to commit to master for 9.1 release
see: https://docs.jboss.org/author/display/TEIID/FROM+Clause
* NO TRIM specified on the TEXTTABLE, it will affect *all column and header values*. *If NO TRIM is specified on a column*, then the fixed or unqualified text value not be trimmed of leading and trailing white space.
{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}
was (Author: blafond):
Basically add a "NO TRIM" check-box to the TEXT TABLE options dialog. This was added in Teiid 8.8, so only need to commit to master for 9.1 release
> Add ui support for whole texttable no trim
> ------------------------------------------
>
> Key: TEIIDDES-2389
> URL: https://issues.jboss.org/browse/TEIIDDES-2389
> Project: Teiid Designer
> Issue Type: Enhancement
> Environment: Teiid 8.8.0 Final
> Reporter: Shiveeta Mattoo
> Labels: File-connector, TEXTTABLE, TRIM
> Fix For: 9.1
>
>
> TEIID-3167 allows for NO TRIM to be specified against the whole texttable regardless of whether it is fixed width or delimited. If delimited, then unqualified entries will not be trimmed. For example:
> a , "b"
> would be parsed as
> a ,b - such that the space is preserved after a, but the qualified entry is unaffected.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month
[JBoss JIRA] (TEIIDDES-2394) Add UI support for TEXTTABLE Custom Line Separator
by Barry LaFond (JIRA)
[ 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}
> Add UI support for TEXTTABLE Custom Line Separator
> ---------------------------------------------------
>
> Key: TEIIDDES-2394
> URL: https://issues.jboss.org/browse/TEIIDDES-2394
> Project: Teiid Designer
> Issue Type: Enhancement
> Components: Teiid Integration
> Reporter: Shiveeta Mattoo
> Labels: FileConnector, TEXTTABLE
> Fix For: 9.1
>
>
> Add UI support for TEXTTABLE capability to support a Custom Line Separator . See https://docs.jboss.org/author/display/TEIID/FROM+Clause with the ROW DELIMITER char option.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
11 years, 1 month