Focal Point
[CLOSED] COMMA TITLE HEXBYT PDF

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

May 09, 2019, 08:29 AM
jenni
[CLOSED] COMMA TITLE HEXBYT PDF
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
May 09, 2019, 08:47 AM
Tony A
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.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
May 09, 2019, 08:51 AM
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



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 
May 09, 2019, 09:16 AM
MartinY
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.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
May 09, 2019, 09:16 AM
Tony A
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.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
May 09, 2019, 09:17 AM
MartinY
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.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
May 09, 2019, 09:20 AM
jfr99
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
May 09, 2019, 09:25 AM
Tony A
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.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
May 09, 2019, 09:29 AM
MartinY
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.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
May 09, 2019, 09:42 AM
jenni
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
May 09, 2019, 09:43 AM
jenni
I just Need PDF, no XLSX or HTML is helpful for me


WebFOCUS 8.1.05
Windows, All Outputs
May 09, 2019, 09:47 AM
jenni
[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
May 09, 2019, 09:49 AM
Tony A
Is your server set for UNICODE?

What codepage are you using?

T



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 
May 09, 2019, 09:50 AM
jenni
@Tony A: no I think it's UTF8
is there a possibility to check?


WebFOCUS 8.1.05
Windows, All Outputs
May 09, 2019, 10:05 AM
Tony A
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.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
May 10, 2019, 10:55 AM
Hallway
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

 
Prod: 8202M1
Test: 8202M4
Repository:
 
OS:
 
Outputs:
 
 
 
 
May 13, 2019, 03:29 AM
jenni
With
-TYPE Client Code Page = &FOCCLIENTCP
-TYPE Language Code Page = &FOCCODEPAGE
I'll get 65001


WebFOCUS 8.1.05
Windows, All Outputs
May 21, 2019, 10:41 AM
FP Mod Chuck
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