[teiid-issues] [JBoss JIRA] (TEIID-3489) Can a function be added to filter certain ASCII chars below 31 and above 127 out of an XML Document

[Debbie Steigner (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13070021#comment-13070021 ] 

Debbie Steigner commented on TEIID-3489:
----------------------------------------

It's happening when trying to parse the result as xml, receives:

Error: Remote org.teiid.api.exception.query.ExpressionEvaluationException: Unable to evaluate XMLPARSE(DOCUMENT f.result): Value is not valid XML
SQLState:  50000
ErrorCode: 0


> Can a function be added to filter certain ASCII chars below 31 and above 127 out of an XML Document
> ---------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-3489
>                 URL: https://issues.jboss.org/browse/TEIID-3489
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>            Priority: Minor
>
> Add a function in Teiid to filter off all ASCII chars below 31 and above 127.
> web service data source that contains control characters due to data entered by copy and paste the text from another system.
> The characters in this instance were the print control chars ASCII 28 and 29, File Separator and Group Separator respectively. These are used for formatting in older systems. Unfortunately, the XML standard prohibits the processing of all ASCII characters below 31 apart from Tab, Line Feed and Carriage Return which are permissible. Also, ASCII chars above 127 to 255 will also cause XML parsers to crash.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)