[SOLVED] Displaying Currency Symbols

Check out http://www.asciitable.com/ and let us know if you still need more info on this.

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Gold member

posted

Here are a few more links that might help :

Link to Ruble Symbol:
http://www.kommersant.com/p-10761/Symbol_ruble/

Link to 8-bit (extended) ASCII table :
http://www.ascii.cl/htmlcodes.htm

I don't see the Ruble in there, but I hope this helps !

WF 7.6.4 & 5.3
Charles Lee

Posts: 93 | Registered: June 17, 2008

Ignored post by Charlz posted

Tom Flynn

Expert

posted

OR

Check out Tony's Post

Tom

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Doug

Expert

posted

I hope that does it Krishkasi,

I've learned something from this. Thanks for asking in the first place.

Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005

Ignored post by Doug posted

Gold member

posted

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

Posts: 93 | Registered: June 17, 2008

Ignored post by Charlz posted

susannah

Expert

posted

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

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Gold member

posted

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

Posts: 93 | Registered: June 17, 2008

Ignored post by Charlz posted

susannah

Expert

posted

chuck...M and N...that does it for $

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Gold member

posted

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

Posts: 93 | Registered: June 17, 2008

Ignored post by Charlz posted

krishkasi

Gold member

posted

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

Posts: 71 | Registered: November 20, 2003

Ignored post by krishkasi posted

FrankDutch

Virtuoso

posted

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

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted

susannah

Expert

posted

you'll need to know what the unicode for the character you want.
start your research here
A tutorial on character code

according to this article in Russia Today
http://www.russiatoday.com/forums/Entertainment/topic/42
there doesn't seem to even be a symbol.

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

and there's this from wiki
http://en.wikipedia.org/wiki/Russian_rouble
the consensus seems to be to use the The ISO 4217 code RUB; , the post-1998 version . (previously RUR). Wiki says there is no current symbol, officially, but
here's a great site listing all the currency symbols

This message has been edited. Last edited by: susannah,

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

FrankDutch

Virtuoso

posted

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

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted