Link to home
Start Free TrialLog in
Avatar of rporter45
rporter45

asked on

Replace function in Crystal Reports

Good afternoon,

I created an export using crystal and was notified that a field could not accept apostrophes - that was fine, I used the following:

Replace({@Name},"'","")

but now they are letting me know that the field can't have commas as well.  I've tried to "build" on the existing formula without luck. Does anyone have any ideas?

thank you,
CS
SOLUTION
Avatar of vasto
vasto
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rporter45
rporter45

ASKER

Both solutions worked perfectly but I did find the second easier to implement because it was straight forward with regard to coding.

Thanks very much to you both,
CS