Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crytal report 9

Status
Not open for further replies.

johnpaulfrace

Programmer
Jul 12, 2012
1
PH
how to replace multiple text in Crystal report 9:
sample //
If InStr({ado.Majors}, 'Engineering') > 0 then replace({ado.Majors},'Engineering','Engr.',1,1)
else
If InStr({ado.Majors}, 'Communication') > 0 then replace({ado.Majors},'Communication','Comm.',1,1)
 
Instead of InStr(), which doesn't exist in Crystal, use Pos().

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year
 
Well, instr() does exist in Crystal, but you probably don't need it. You could just use nested replaces, like this:

replace(replace({ado.Majors}, 'Engineering','Engr.'),'Communication','Comm.')

...etc.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top