Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] COMMA TITLE HEXBYT PDF
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] COMMA TITLE HEXBYT PDF
 Login/Join
 
Platinum Member
posted
Hi,

I Need to create a title with a comma.
The comma Needs to be visible and does not Need to create a line break.

Tried everything with HEXBYT(44, 'A1') but it does not work..

Any ideas??

Thanks.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
Hi Jenni,

If you only want HTML output then try the following -

TABLE FILE CAR
SUM RCOST AS 'Retail&|subqo;Cost'
BY COUNTRY
BY CAR
BY MODEL
END


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5610 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
… for PDF/XLSX output, you could use the following -

-SET &Comma = HEXBYT(130,'A1');
-SET &RCOST_TITLE = 'Retail&Comma.EVALCost'
TABLE FILE CAR
  SUM RCOST AS &RCOST_TITLE.QUOTEDSTRING
   BY COUNTRY
   BY CAR
   BY MODEL
ON TABLE PCHOLD FORMAT PDF
END


T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5610 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Or (tricky way but it works)

&XTITLE will work with HTML only
-SET &XTITLE = 'AUTO' | '&|#44;' | 'MOBILE';
DEFINE FILE CAR
'AUTO,MOBILE'/A20 = CAR;
END

TABLE FILE CAR
PRINT CAR AS &XTITLE
      'AUTO,MOBILE'
      COMPUTE 'MOBILE,AUTO'/A20 = CAR ;
BY COUNTRY
ON TABLE PCHOLD FORMAT PDF
END


@Tony : yours first option is not working at all with any format and second one doesn't work with XLSX nor EXL2K, only HTML, PDF Frowner


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2192 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
second option doesn't work with XLSX nor EXL2K

Does for me, both formats.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5610 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
Originally posted by Tony A:
quote:
second option doesn't work with XLSX nor EXL2K

Does for me, both formats.

T


Hummmmm
Related to code page, NLS settings ?...


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2192 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
This works for me in HTML, XLSX, PDF and EXL2k ...

-*
-SET &Comma = HEXBYT(130,'A1');
-*
TABLE FILE CAR
SUM RCOST AS 'Retail&Comma.EVALCost'
BY COUNTRY
BY CAR
BY MODEL
ON TABLE PCHOLD FORMAT XLSX
END


WebFocus 8.201M, Windows, App Studio
 
Posts: 221 | Location: Lincoln Nebraska | Registered: August 12, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
first option is not working at all with any format

Mistype for the HTML variable
- should be &|sbquo not &|subqo

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5610 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I can see in the source that &Comma it's a "," when I -TYPE &Comma
But Excel cannot display the comma.
I have a square at the comma position such as when an image cannot be displayed...

Probably related with regional settings... I must have I look into this.


WF versions : Prod 8.2.0.1M gen 240, Dev 8.2.04 gen 48, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
 
Posts: 2192 | Location: Montreal Area, Qc, CA | Registered: September 25, 2013Reply With QuoteReport This Post
Platinum Member
posted Hide Post
quote:
Originally posted by Tony A:
… for PDF/XLSX output, you could use the following -

-SET &Comma = HEXBYT(130,'A1');
-SET &RCOST_TITLE = 'Retail&Comma.EVALCost'
TABLE FILE CAR
  SUM RCOST AS &RCOST_TITLE.QUOTEDSTRING
   BY COUNTRY
   BY CAR
   BY MODEL
ON TABLE PCHOLD FORMAT PDF
END


T



it doesn't work, it Shows me a box where the comma is supposed to be.

Working with 8204


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I just Need PDF, no XLSX or HTML is helpful for me


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Platinum Member
posted Hide Post
[quoteDEFINE FILE baseapp/CAR
'AUTO,MOBILE'/A20 = CAR;
END

TABLE FILE baseapp/CAR
PRINT
'AUTO,MOBILE'
ON TABLE PCHOLD FORMAT PDF
END[/quote]

´Works, but the next Thing is, that there are other commas, which Needs to line break my Text.

So something with HEXBYT(44, 'A1') would be better, sothat I can differ between real commas and line break commas... :/ Little tricky


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
Is your server set for UNICODE?

What codepage are you using?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5610 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Platinum Member
posted Hide Post
@Tony A: no I think it's UTF8
is there a possibility to check?


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Expert
posted Hide Post
I don't have an install configured with UTF8 but you could try -

-SET &Comma = HEXBYT(8218,'A1');


Look for an alternative character within the character sets available within your configuration.

The important thing is that char 44 will always cause a break within WF titles so you need to find an alternative - for me using ASCII, 130 did the trick.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5610 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Guru
posted Hide Post
quote:
Originally posted by jenni:
@Tony A: no I think it's UTF8
is there a possibility to check?


Try the following to check what the code page is:

 
-TYPE Client Code Page   = &FOCCLIENTCP	
-TYPE Language Code Page = &FOCCODEPAGE 


Hallway
WF(Prod):8202M
WF(Test):8202M
OS/Platform:Win 10
Outputs:All
 
Posts: 455 | Location: Salt Lake City, UT, USA | Registered: November 18, 2015Reply With QuoteReport This Post
Platinum Member
posted Hide Post
With
-TYPE Client Code Page = &FOCCLIENTCP
-TYPE Language Code Page = &FOCCODEPAGE
I'll get 65001


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 177 | Registered: October 17, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Jenni

If this is still an issue please open a case with techsupport.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1634 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] COMMA TITLE HEXBYT PDF

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