Hello, CR2008, Oracle I need he 1

[Corres]

Hello,
CR2008, Oracle

I need help with a string formula.

Example of Data:

SART EXIT - Dave, Lisa - 2012-03-09
EX- SART - WUERCH - DEC 9, 2011
FIPD PERM 1 EXIT - Robert Yfdfhiuki - April 11 2011
FIPD PERM 1 EXIT - Rob Zfduuya - April 82011

Results Needed:
2012-03-09
DEC 9, 2011
April 11 2011
April 82011

I was trying

TrimRight (
right({INCIDENT.CALLBACK_RMK},(instr({INCIDENT.CALLBACK_RMK},'-') )
)
)
But it works only for the first row.
Any help would be great. Thanks.

 

[briangriffin]

Is it always the third element? If so this will work:


split({INCIDENT.CALLBACK_RMK}," - ")[3]


If it's not always three, but is always the last element:

split({INCIDENT.CALLBACK_RMK}," - ")[ubound(split({INCIDENT.CALLBACK_RMK}," - "))]

 

[Corres]

That exactly what I need, thank you so much!