I unfortunately can't tell you what's wrong with that statement...but I CAN tell you that there is a RegEx Plugin that may do what you are looking for
https://communities.bmc.com/thread/53307?start=0&tstart=0 On Wed, Apr 24, 2013 at 7:51 AM, Atul Vohra <[email protected]>wrote: > ** > > All, > > I am trying to parse a remedy field ex: > > Remedy Field X = 'SMITH^ALLENX^WARD^JONES' > > > > Output saved in 4 different remedy fields > > > SMITH > > ALLENX > > WARD > > JONES > > > I have an filter that has a set field action with Data Source = SQL and > SQL QUERY - > > select regexp_substr('$X$','[^^]+', 1, level) from dual > connect by regexp_substr('$X$','[^^]+', 1, level) is not null; > > In the sql log I see the following - > select regexp_substr('SMITH^ALLENX^WARD^JONES','[^^]+', 1, level) from > dual > connect by regexp_substr('SMITH^ALLENX^WARD^JONES','[^^]+', 1, level) is > not null; > > *** ERROR *** ORA-00911: invalid character > > The same query above works fine in sql plus. > > We are on ARS 8.0, Oracle 11 g > > What am I doing wrong here? I could write a filter guide and parse it but > was not sure what is wrong here. > > Thanks > Atul > > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
