IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Add multiple spaces in concat when output is FORMAT WP
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Silver Member
Posted
Hi,

I have the following situation:
field1 is xxxxxxx and field2 is xxxxxxxxx, I want to concat them but leave multiple spaces i.e. 10 spaces between the two fields.
I have tried this sort of solution:
 FIELD1 || ('          ' | FIELD2) 

But it does not work. I also cannot use the following option as the output is not HTML:
-SET &SPACE='&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;';  


Does anyone know of a way around this?

Thanks!


7.6.2
Windows
HTML, PDF and Excel
 
Posts: 29 | Location: UK | Registered: February 07, 2008Reply With QuoteEdit or Delete MessageReport This Post
Expert
Posted Hide Post
This appears to work in WF 5.3.2 and WF 7.6.5:

FILEDEF H01 DISK TESTFM/H01.WP
-RUN

TABLE FILE CAR
PRINT
COMPUTE TEST1/A100 = MODEL || ('          ' | COUNTRY);
ON TABLE HOLD AS H01 FORMAT WP
END
-RUN


Francis



Env 1: WebFOCUS 5.3.2 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - IIS/New Atlanta ServletExec - MS SQL Server 2000 - DataMigrator 5.3.4
Env 2: WebFOCUS 7.6.5 Servlet - MRE/BID/Self Service - MS Windows XP SP2 - Apache Tomcat/5.5.25 - MS SQL Server 2000
Env 3: WebFOCUS 5.3.3 CGI - Self Service - AIX 5.2 - IBM DB2
Output formats: HTML, Excel 2000 and PDF
 
Posts: 3379 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Add multiple spaces in concat when output is FORMAT WP

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