Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] pound sign not displaying correctly

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] pound sign not displaying correctly
 Login/Join
 
ReddyP
Gold member
posted
Hi,
I need to display mixed currency symbols in a column. I converted the amount to alpha value and appending the currency symbol based on the currency convention column.
For example: I have currency convention as GBP, USD, AUD etc.,
and a column for amount.
Based on the currency convention, I have a define
as if GBP then display pound , if AUD then display AUD
else display $'.
but pound symbol comes up as ú instead of £.
I am using POUND/A1=HEXBYT(163, 'A1'); for pound sign.
Am I doing something wrong.
I tried in HTML and Excel and both of them are giving me wrong symbol.
Any advice please.
Thanks.

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


7.7.01,windows2008 R2
 
Posts: 65 | Registered: July 28, 2011Report This Post
Dan Satchell
Virtuoso
posted Hide Post
I haven't tried this, but it might provide another approach that doesn't require converting your amounts to alpha format. First set the default currency to AUD. Then use the currency options to format your amount field for the other currencies. The format should default to AUD if you don't specify a currency option in the format.

SET CURRSYMB = 'AUD'
-*
DEFINE FILE xxx
 CURRFMT/A10 = IF (CURRENCY EQ 'DOLLAR') THEN 'D12.2!D' ELSE
               IF (CURRENCY EQ 'EURO')   THEN 'D12.2!E' ELSE
               IF (CURRENCY EQ 'GBP')    THEN 'D12.2!L' ELSE
               IF (CURRENCY EQ 'YEN')    THEN 'D12.2!Y' ELSE 'D12.2';
END
-*
TABLE FILE xxx
 PRINT AMOUNT/CURRFMT
END


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Using the CAR file, I created a simple working example:

SET CURRSYMB = 'AUD'
-*
DEFINE FILE CAR
 CURRENCY/A6 = DECODE COUNTRY ('ENGLAND'   'GBP'
                               'FRANCE'    'DOLLAR'
                               'ITALY'     'EURO'
                               'JAPAN'     'YEN'
                               'W GERMANY' 'AUD'
                                ELSE       '');
 CURRFMT/A10 = DECODE CURRENCY ('DOLLAR' 'D12!D'
                                'EURO'   'D12!E'
                                'GBP'    'D12!L'
                                'YEN'    'D12!Y'
                                 ELSE    'D12M');
END
-*
TABLE FILE CAR
 PRINT
  COUNTRY
  CAR
  RETAIL_COST/CURRFMT
END

This message has been edited. Last edited by: Dan Satchell,


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
ReddyP
Gold member
posted Hide Post
Thank you for your response Dan.
But, this would not work for me because
if the amount is AUD (Australian Dollar), I need to have AUD at the end.
For example:
for dollar, $1234
for GBP, £1234
for AUD, 1234 AUD.


7.7.01,windows2008 R2
 
Posts: 65 | Registered: July 28, 2011Report This Post
Danny-SRL
Virtuoso
posted Hide Post
I tried your POUND and I see £.
I suggest you look at the code page you are using.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] pound sign not displaying correctly

Copyright © 1996-2020 Information Builders