Hi,
Why not do it in a FLTR/ACTL Set-Fields Action? It will work for any
database.
Starting with a tmp-value of "abc:xyz:def" containing exactly 3 colons.
Action 1:
Set-Fields:
result = LEFTC(STRSTRC($tmp$, ":"))
Action 2:
Set-Fields:
tmp = SUBSTRC($tmp, STRSTRC($tmp$, ":") + 1)
Action 3:
Set-Fields:
result = $result$ + "
" + LEFTC(STRSTRC($tmp$, ":")) + "
" + SUBSTRC($tmp, STRSTRC($tmp$, ":") + 1)
The result should be the following string:
"abc
xyz
def"
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.
> 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"
>
> --
> 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"
