[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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3489:
---------------------------------------

I couldn't ascertain at what point this function will be used.  Is this for converting a clob/blob into xml?  Or is this for sending a value out for inclusion into an xml 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)