Remove Unwnated Characters

[SMosley804]

Crystal Reports Developer v11
IBM DB2


I have a field that has unwanted characters in the string. I want to remove those unwanted characters.

ex.

The field value= lbzds01:TEP

I want to remove everything after the colon.

 

[lbass]

To also remove the colon, use:

left({table.field},instr({table.field},":")-1)

To leave the colon in:

left({table.field},instr({table.field},":"))

-LB