Bug 1328303 - Substring function to search a string for regular expression pattern
Summary: Substring function to search a string for regular expression pattern
Keywords:
Status: CLOSED WONTFIX
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.1.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: jolee
QA Contact: Filip Elias
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-04-19 01:43 UTC by Anu Saji
Modified: 2019-10-10 11:54 UTC (History)
7 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
SQL Server JDV 6.1
Last Closed: 2016-04-21 20:42:06 UTC
Type: Feature Request


Attachments (Terms of Use)

Description Anu Saji 2016-04-19 01:43:22 UTC
Description of problem:

In customers words
~~~
1. Can I use regular expressions to transform the values that come from the data source?
For example without regular expression:
Query: Select Field from Table
Result: "Hello World" # "# (" ($ "# ($!" #% $ = °°°:! [* [* "

With regular expression:
Query: Select ???? from Table
Result: "Hello World"

~~~



Additional info:
Customer might be looking for similar REGEX Functions provided in Oracle like 
~~~
https://docs.oracle.com/cd/B28359_01/server.111/b28286/functions138.htm
~~~

for example
~~~
SELECT
  REGEXP_SUBSTR('500 Oracle Parkway, Redwood Shores, CA',
                ',[^,]+,') "REGEXPR_SUBSTR"
  FROM DUAL;

REGEXPR_SUBSTR
-----------------
, Redwood Shores,
~~~


Note You need to log in before you can comment on or make changes to this bug.