How can I break out two different values in an Oracle string field (20) and trim off the leading zeros as well as capture specific values.
In the image here.
I have a string field (20) with values that have a leading set of characters like "CO" , NPC" and or "QU" followed by a dash " - " or two " -- " then a value like 00003. I need to :
1. consistently pull the value called CO, NPC, QU or whatever is before the dash " - " or two " -- "
2. retrieve the numeric set no matter how long or short the value after the dash " - " so that if the value is "00003" the value should display as just "3"
What I think I need some combination of the following Crystal Reports Functions:
If Then Else or Select Case
Instr (???) and or InstrRev (???)
Maybe the Trim function and or ToNumber?
I am not sure what is the best way to do this and appreciate any result you can get me. Thank you.....in advance.