[SOLVED] Unwanted extra spaces after amper variable
I have an amper variable in my report header that is followed by a / character then another amper variable and should display as 01/2008 however it displays as 01 / 2008 in HTML output.
Has anyone run into this before and if so is this a kerning issue or is there a way aroung it?This message has been edited. Last edited by: Kerry,
WebFOCUS 7.6.2 Windows XP HTML, Excel
March 13, 2009, 03:33 PM
ypatel
You can use -SET &NEWVAR = TRUNCATE(&VAR) to remove any trailing spaces from &VAR.
-Yogesh Patel ------------------------------------------------------------------------ PROD: WF 764 on Linux Apache tomcat v5.5 DEV: WF 768 on Linux
March 14, 2009, 03:06 PM
susannah
so your heading looks like this, i imagine HEADING "&MONTH / &YEAR " is that it? so try this HEADING "&MONTH/&YEAR" .. if that doesn't do it, then your inbound &vars have blanks in them; -SET &MYHEADING = &MONTH || '/' || &MYYEAR ; you'll note that double concat doesn't always help with &vars, so look up the STRIP function to remove blanks (or any other char); The HELP button in DevStu is the quickest way to get the defintion of a function like STRIP. -s.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
March 14, 2009, 03:54 PM
Danny-SRL
Mike,
The easiest: use the vertical bar | after your first &variable:
-* File MikeD1.fex
-SET &MO='03';
-SET &YR='2009';
TABLE FILE CAR
HEADING
"&MO|/&YR"
BY COUNTRY
END
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
March 16, 2009, 08:44 AM
Mike_D
Thanks everybody. I am now getting the desired results. From now no more shift + drag and drop in report painter!