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.
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.