Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hello, CR2008, Oracle I need he 1

Status
Not open for further replies.

Corres

Technical User
Jun 13, 2006
87
CA
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.
 

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}," - "))]


 
That exactly what I need, thank you so much!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top