Hi Doug,
That looks simple enough ;-)
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> 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
> [email protected]
> +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"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
>
>
> _______________________________________________________________________________
> 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"
