I am currently printing a report that contains the employers of people. Some employers have a '&' in their name, which ruins things. I am currently using

 STRREP(60, EMPLOYER, 1, '&', 2, '&|', 61, EMPLOYER); 

which is supposed to replace an ampersand with &|, but it still does not work. Is there any other way to do this?

This message has been edited. Last edited by: ccollier,

Try adding an extra pipe.

STRREP(60, EMPLOYER, 1, '&', 2, '&||', 61, EMPLOYER);

is it being ruined with a .EVAL or something? Do you have a sample of th ecode where it breaks?

You could try the simplified replace function as well:

  
REPLACE(EMPLOYER, '&', '&|amp;')

You could also try the HEXBYT function to replace the amper

 
REPLACE(EMPLOYER, '&', HEXBYT(38, 'A1') )
 

I've dealt with this. Webfocus won't allow you to search for &, but you can get around that by telling it search for the &| with the | removed. Example below:

Part one - search for this character
STRIP(2, '&|', '|', 'A1')

Part Two - use replace characters searching for character in part one
REPLACE(EMPLOYER, part_one , '&||');

Full code
REPLACE(EMPLOYER, STRIP(2, '&|', '|', 'A1'), '&||');


Webfocus 8202 on Windows 10

I used a bit of Hallway's first solution. I still used STRREP but used &|amp; instead of just &| and it worked.