Replace

[LEO037]

In VB there is a function to do a replace. For example,

NoHyphens = Replace("1-800-555-1212", "-", vbNullString)

which gives you:
18005551212


Does anyone know how to do the same in Crystal Reports?

What I really need to do is replace a double apostrophe, which resides in a table field, with a single apostrophe.
The data will be displayed on the report with one apostrophe. As it stands now, the data is displaying with
double appostrophe.

Thanks

 

[kenhamady]

New in CR, V8:

Replace (inputString, findString, replaceString)

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[LEO037]

So in other words, I will now have to "replace" the old version
of CR 7.0 with 8.0. Just to fix this one little problem? oh well!
Another bullet to bite.

Thanks for the help.
Leo

 

[kenhamady]

There is a UFL that works with older versions. You can get it from the following link:

http://support.seagatesoftware.com/communityCS/FilesAndUpdates/uflrepl.exe.asp

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal