Hi I want to display currency symbol as part of the column title on a PDF report.
I have decided to use the HEXBYT function to produce Pound and Euro symbol. But I want to produce the Russian Ruble symbol which is a combination of english letter p and y and numeric 6 like character. I wanted to know what decimal value to be used in the HEXBYT fucntion to produce that 6 like character.
If you have any idea, pls share with me.This message has been edited. Last edited by: Kerry,
Regards, Kasi Krishnan WF 7.1.4 & WF 7.6.9: Databases - DB2, SQL Server 2000. OS: Windows & AIX
I've learned something from this. Thanks for asking in the first place.
October 03, 2008, 10:39 PM
Charlz
You might also try searching 16-bit ASCII Eurocodes for a wealth of special characters, although I can't verify if they will work in WF without tweaking your code a little ?
WF 7.6.4 & 5.3 Charles Lee
October 05, 2008, 12:02 PM
susannah
at the risk of belabouring the point, but perhaps of value to future searchers...
EURO/D8.2!e or EURO/D8.2!E or STERLING/D8!l or STERLING/D8!L are currency formats existing in webfocus. they operate like M and N One puts Euro symbol on all numbers the other puts Euro symbol on only the first and subtotals. I leave it to you to organize which is which -s
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
October 05, 2008, 05:37 PM
Charlz
Thanks Susannah !
That certainly does NOT belabor the point !
Looks like the ‘!’ invokes a library or something ? I’m new, so this may be obvious to some ?
However, it works like a charm on the CAR file !
TABLE FILE CAR
COMPUTE European/D8.2!E = RETAIL_COST;
COMPUTE European/D8.2!e = RETAIL_COST;
COMPUTE British/D8.2!L = RETAIL_COST;
COMPUTE British/D8.2!l = RETAIL_COST;
COMPUTE US/D8.2M = RETAIL_COST;
-* COMPUTE US/D8.2m = RETAIL_COST; -* doesn't work on 'M' though
END
As a 'future member' I appreciate this kind of response.
The uppercase E or L puts the ‘€’ or ‘£’ on EVERY line, and lowercase puts them just on the first and total lines.
Too bad that doesn’t work for US ‘$’ though.
Is there one for Rubles ? I looked in ‘Help’ for this and couldn’t find it.
Simple and to the point - what a concept !
Thanks
WF 7.6.4 & 5.3 Charles Lee
October 05, 2008, 10:59 PM
susannah
chuck...M and N...that does it for $
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
October 06, 2008, 01:19 AM
Charlz
Hi Susannah
The "M" and "N" were probably part of the original FOCUS language, long before WebFOCUS and Eurocode, and L/l and E/e seem to be their more modern counterparts ?
If "M" and "N" had been written into WF more recently, it might have been "M and m" ? We'd run out of alphabet with all the new countries and their currency symbols !
Thanks for the update on the "M and N" formats (and for the ‘€’ or ‘£’ before that).
Charlie
WF 7.6.4 & 5.3 Charles Lee
October 11, 2008, 07:46 PM
krishkasi
Thanks all for your comments and examples. But I want to display Russian Ruble Symbol as part of the column heading (title).
I have tried to find the decimal value for that 6 like character in the charts to be used via HEXBYT function. But I have no luck with it.
Regards, Kasi Krishnan WF 7.1.4 & WF 7.6.9: Databases - DB2, SQL Server 2000. OS: Windows & AIX
October 12, 2008, 06:13 AM
FrankDutch
I would suggest to always use the international ISO-4217 codes instead of '$' ‘€’ or ‘£’ or 'R' (the last one is the official sign for the Rubel, you do not need an Cyrillic character to display this) Those special characters makes it not always easy, you need the character set and in graphs or pdf documents they also give me problems.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
October 12, 2008, 09:00 AM
susannah
you'll need to know what the unicode for the character you want. start your research here A tutorial on character code
and according to the digital conversion person at the library of congress, "there was a competition in 1998 but it went nowhere. Duma Deputy Pavel Krasheninnikov has introduced legislation to create a new symbol but the Central Bank calls his initiative pointless ..."
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
October 12, 2008, 09:16 AM
FrankDutch
Susannah
That might be a good idea but if you go back in history to the first printing machines you will find out that the first Russian printers were introduced by Tsaar Peter the Great after his visit to the Netherlands. He ordered an company her in my country to deliver such a machine but with the Cyrillic characters. The company asked him to write these letters. After he did that they found out that it was not so easy and since there was not much time they used our "normal" characters, sometimes in an other sequence and sometimes with some tricks. If you should study the Russian alphabet you will see that several characters are flipped Latin characters (both horizontal and vertical).
The "old" dollar, pound and other characters were in fact short hands for written text, The first currency notes were also handwritten, the Iso standards for currency are much more secure and better in our computer era...
Just some thoughts....
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7