How do I remove a $ from a text value? 1

[python138]

I have the following formula in Crystal v8.5:
" Face Value : "+ ToText ({acrlrpt.face_value})+" "
+ " Interest Rate : " + ToText ({acrlrpt.rate},6)+"%"

The problem is I have multiple currencies and the first character of the acrlrpt.face_value is always "$". I would like to remove the "$" but need to leave it as a text string. I have tried a couple remove commands but can't seem to get it right.

Any Ideas?

 

[mbarron]

This should do the trick:

" Face Value : "+ right(ToText ({acrlrpt.face_value}),len(ToText ({acrlrpt.face_value}))-1)+" "
+ " Interest Rate : " + ToText ({acrlrpt.rate},6)+"%"


Mike