Focal Point
[SOLVED] Unwanted extra spaces after amper variable

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/18410134

March 13, 2009, 02:29 PM
Mike_D
[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!


WebFOCUS 7.6.2
Windows XP
HTML, Excel