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
�
�
�
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
