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,

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

… 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

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

quote:

second option doesn't work with XLSX nor EXL2K

Does for me, both formats.

T

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 ?...

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

quote:

first option is not working at all with any format

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

T

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.

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

I just Need PDF, no XLSX or HTML is helpful for me

[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

Is your server set for UNICODE?

What codepage are you using?

T

@Tony A: no I think it's UTF8
is there a possibility to check?

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

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 

With
-TYPE Client Code Page = &FOCCLIENTCP
-TYPE Language Code Page = &FOCCODEPAGE
I'll get 65001

Jenni

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