Hi All,
I've string inputs with "|" DELIMITERS as below:
|Schreiber's Deli & Catering|Calabria Pizza|Jade Dragon|
|The Oak House|Asset Milestone|
|regulatory Filing|
I am trying to use regular expression REPLACE instead of nesting multiple normal REPLACE&TRIM functions as ive written below.
Requirement:
------------
To remove from the string the start '|' and end '|' but replace the intermediate '|' with ', '
my query gives correct output as below but i want to user REGULAR EXPRESSION instead:
select replace(ltrim(rtrim('|fhhgngng|dffngng|','|'),'|'),'|',', ') from dual ---> fhhgngng, dffngng
output from above samples:
--------------------------
|Schreibers Deli & Catering|Calabria Pizza|Jade Dragon| -------------> Schreibers Deli & Catering, Calabria Pizza, Jade Dragon
|The Oak House|Asset Milestone| -------------> The Oak House, Asset Milestone
|regulatory Filing| -------------> regulatory Filing
How can i use regular expression instead?
Oracle 12C.
thanks.