Focal Point
Retaining Trailing Space between two columns

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

February 03, 2006, 07:40 AM
thangam
Retaining Trailing Space between two columns
My Report o/p format is PDF.

The sample code is as follows
DEFINE FILE TEST
V_FNAME/A10=' ';
V_LNAME=/A20=V_FNAME|' TEST';
END

TABLE FILE TEST
PRINT
V_LNAME
V_DATE
ON TABLE SET ONLINE-FMT PDF
END

When I concatenate (weak concatenation used) two fixed length variables, if one variable is stored with space, space is not getting displayed in the report report.

The name o/p should be " Test"

But I am getting "Test"

How can I retain this space?

Please guide me.
February 03, 2006, 08:42 AM
mgrackin
The following code seems to work but gives 10 spaces before the ' TEST'. I added two more fields to demonstrate how each works.

DEFINE FILE CAR
M_FNAME/A10 WITH COUNTRY='----------';
M_LNAME/A20 WITH COUNTRY=M_FNAME|' TEST';
V_FNAME/A10 WITH COUNTRY='-';
V_LNAME/A20 WITH COUNTRY=V_FNAME|' TEST';
X_FNAME/A10 WITH COUNTRY=' ';
X_LNAME/A20 WITH COUNTRY=X_FNAME||' TEST';
END

TABLE FILE CAR
PRINT M_LNAME OVER V_LNAME OVER X_LNAME
ON TABLE SET ONLINE-FMT PDF
END

I hope this helps.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
February 03, 2006, 09:15 AM
Tony A
Removing the typos to give -
DEFINE FILE TEST
V_FNAME/A10=' ';
V_LNAME/A20=V_FNAME|' TEST';
END

TABLE FILE TEST
PRINT
V_LNAME
-*V_DATE
ON TABLE SET ONLINE-FMT PDF
END
I get TEST preceded by 11 spaces.

T

p.s. are you using proportional fonts?



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
February 03, 2006, 02:14 PM
susannah
and the ever-popular
V_LNAME/A20=V_FNAME|'&|nbsp;TEST';




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID