[SOLVED] Append Ampersand to Set Variable?

I have a set variable that I use in a report header. I need to make an update to the value in this variable based on a department name change. The new value includes an ampersand (&) value, which WebFOCUS seems to be reading as the beginning of a prompt instead of as just a text character.

Is it possible to update the variable below to include this text character? (I'm looking to change "Department ABCD" to "Department ABC&D")

  
SET ASNAMES = ON

-SET &HEAD1  ='"'|'Department ABCD'|'"';

TABLE FILE CAR
PRINT
COUNTRY

WHERE RECORDLIMIT EQ 100

HEADING
&HEAD1.EVAL

ON TABLE PCHOLD FORMAT EXL2K
END
-EXIT

This message has been edited. Last edited by: <Kathryn Henning>,

Production - 7.6.4
Sandbox - 7.6.4

Posts: 241 | Location: Bethesda, MD | Registered: August 14, 2007

RSquared

Guru

posted

Hide Post

try this instead
quote]SET ASNAMES = ON

-SET &HEAD1 ='"'|'Department'|' ABC'|'& '|'D'|'"';

TABLE FILE CAR
PRINT
COUNTRY

WHERE RECORDLIMIT EQ 100

HEADING
&HEAD1.EVAL

ON TABLE PCHOLD FORMAT EXL2K
END
-EXIT[/quote]

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

Posts: 398 | Registered: February 04, 2008

Ignored post by RSquared posted

Show Post

susannah

Expert

posted

Hide Post

-SET &DEPT = 'DEPT ABC&|D' ;

-TYPE &DEPT