eo
MIS
- Apr 3, 2003
- 809
Hi
I am doing webstats reports showing which search phrase was enetered to bring a user to our website. The format in the referer address is for example ...tertiary+education (where + represents a space), or %22tertiary+education%22 (where %22 represents "
, and so on (there is a wjhole list of codes).
What I need to do is strip the codes out of the search phrase, and thought of doing this with the replace function in Crystal, BUT...
To do a single replace is fine, e.g. replace ({field}, '+', ' ') and this works fine. BUT this is not the only code that must be replaced, and as soon as I add another variable, errors occur. I have tried the following:
replace ({field}, '+', ' ') or
replace ({field}, '%22', '"')
replace ({field}, '+', ' ') and
replace ({field}, '%22', '"')
replace ({field}, '+', ' ') else
replace ({field}, '%22', '"')
But no luck. I know this is possible as I have seen it done before, but the layout of my formula is incorrect. Can someone help?
EO
I am doing webstats reports showing which search phrase was enetered to bring a user to our website. The format in the referer address is for example ...tertiary+education (where + represents a space), or %22tertiary+education%22 (where %22 represents "
What I need to do is strip the codes out of the search phrase, and thought of doing this with the replace function in Crystal, BUT...
To do a single replace is fine, e.g. replace ({field}, '+', ' ') and this works fine. BUT this is not the only code that must be replaced, and as soon as I add another variable, errors occur. I have tried the following:
replace ({field}, '+', ' ') or
replace ({field}, '%22', '"')
replace ({field}, '+', ' ') and
replace ({field}, '%22', '"')
replace ({field}, '+', ' ') else
replace ({field}, '%22', '"')
But no luck. I know this is possible as I have seen it done before, but the layout of my formula is incorrect. Can someone help?
EO