Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Replacing an ampersand with &|
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Replacing an ampersand with &|
 Login/Join
 
Gold member
posted
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,


WebFOCUS 8.2.01M on Windows 10
 
Posts: 54 | Registered: July 30, 2018Reply With QuoteReport This Post
Expert
posted Hide Post
Try adding an extra pipe.

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


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6254 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Guru
posted Hide Post
is it being ruined with a .EVAL or something? Do you have a sample of th ecode where it breaks?


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 424 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport This Post
Master
posted Hide Post
You could try the simplified replace function as well:
  
REPLACE(EMPLOYER, '&', '&|amp;')


Hallway
WF(Prod):8202M1
WF(Test):8202M4
OS/Platform:Win 10
Outputs:All
 
Posts: 564 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Master
posted Hide Post
You could also try the HEXBYT function to replace the amper
 
REPLACE(EMPLOYER, '&', HEXBYT(38, 'A1') )
 


Hallway
WF(Prod):8202M1
WF(Test):8202M4
OS/Platform:Win 10
Outputs:All
 
Posts: 564 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 10 | Registered: February 12, 2019Reply With QuoteReport This Post
Gold member
posted Hide Post
I used a bit of Hallway's first solution. I still used STRREP but used &|amp; instead of just &| and it worked.


WebFOCUS 8.2.01M on Windows 10
 
Posts: 54 | Registered: July 30, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Replacing an ampersand with &|

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.