Thanks
I came up with the following sql that did the trick:
select regexp_substr('field', '[^:]+', 1, level) from dual
connect by regexp_substr('field', '[^:]+', 1, level) is not null
Atul Vohra
-----Original Message-----
From: "Doug Blair" [d...@blairing.com]
Date: 05/18/2010 09:53 AM
To: arslist@ARSLIST.ORG
Subject: Re: spliiting a string in remedy
Atul,
How about REPLACE('your_field',":","
")
?
... with a newline between those last two double quotes
Doug
On May 17, 2010, at 6:56 PM, Atul Vohra wrote:
> All,
>
> I am wondering if there is an oracle sql call that would split a character
> field content -ex abc:xyz:def should return
> abc
> xyz
> def
>
> Could do it in remedy but was looking to get in one call.
>
> Thanks
> Atul
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Doug
--
Doug Blair
d...@blairing.com
+1 224-558-5462
200 North Arlington Heights Road
Arlington Heights, Illinois 60004
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
