Return porion of string before '-'

[bluraz]

Crystal XI

I have a string field that returns a result of ######-##. (i.e.: 123456-06)
I need a formula to suppress the '-06' and return a result of only '123456'.
I then need another formula to suppress the '123456', and return a vaule of '-06'.

Any help would be very much appreciated. This is the last step to this report and will complete my day!!

 

[synapsevampire]

Try:

For the first:
split({table.field},"-")[1]

and for the second:
split({table.field},"-")[2]

-k

 

[satinsilhouette]

you will need the instr function to accomplish this. There are examples in the help files.

Something like:

if left(trim({dbfield}, instr({dbfield}, "-")= 0 then
trim({dbfield}, instr({dbfield},"-") else

etc.

Thanks so much!
satinsilhouette

 

[bluraz]

synapsevampire

Thank you very much!! Yours worked perfectly, as always!!


satinsilhouette - Thank you for your reply. With the success of synpsevampire's post, I did not try your suggestion.