During a recent Crystal Reports XI training course I was asked "How do I replace the dashes with spaces in the phone field?"
Solution:
In Crystal Reports 7.0 - 2008, to replace one set of characters with
another set of characters, one can use the Replace function.
To replace the dashes with spaces in the field, one can use the following formula:
Replace ({Tablename.FieldName}, "-", " ", 1, -1, 1)
If you have any questions, or need any
assistance, please do not hesitate to Contact Us
|
