[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=13069949#comment-13069949 ] 

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

Their web service datasource response document has invalid characters and the source provider will not correct it, so they want a way to parse out the invalid ASCII characters.  So they would want to convert to string and parse out the characters from anywhere in the document.

> 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)