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.
Hi Leah, I have just come across this when moving code from 7.7.2 to 7.7.03. The CTRAN function is now displaying an a with a ` above it whereas before it was blank. What no. did you change to 160 to ? Regards, Ian
quote:
Originally posted by Leah: SP/A1....
It's fine for me under 4.3.6. Shows space.
Perhaps your browser has a different default language. In ASCII the 160 under extended is actually the a with the ` above it.
I know when we went from mainframe to ascii world we had an issue with conversion using the CTRAN function. Had to change the number we were using.
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
Many thanks J.Gross for your suggestion however the code below produces different results in 7.7.2 than in 7.7.3 - results are shown for both. The 7.7.3 version shows the á symbol. Any reason for the change ?
DEFINE FILE CAR SP/A1 = HEXBYT(160, 'A1'); SP1/A1 = ' '; SP2/A10 = CTRAN(1,SP1,32,160,SP2) END -* TABLE FILE CAR PRINT SP SP2 COUNTRY END -RUN
results from 7.6.2...... PAGE 1
SP SP2 COUNTRY ENGLAND JAPAN ITALY W GERMANY FRANCE
results from 7.7.3...... PAGE 1
SP SP2 COUNTRY á á ENGLAND á á JAPAN á á ITALY á á W GERMANY á á FRANCE
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
Hi Tom, Yes normally I could do this but as I am holding the output so that it can be passed to an html page the showblanks doesn't work. The idea is to line up the fields in a drop down list for ease of reading.
VALUESAM/A15 = FTOA(SETT_AMNT,'(D15.2c)','A15') ; -*nb. ascii 160 below produces a nice non-printable character ie. a space but html -* treats it if it is a normal character ie. maintains leading blanks VALUEUS/A15 = CTRAN(15, VALUESAM, BYTVAL(' ','I2'), 160, 'A15'); ACCTHTY/A2 = CTRAN(2, ACCT_HTYP, BYTVAL(' ','I2'), 160, 'A2'); ACCTNUM/A9 = CTRAN(9, ACCT_HNUM, BYTVAL(' ','I2'), 160, 'A9'); CURRCDE/A3 = CTRAN(4, SETT_CURR, BYTVAL(' ','I2'), 160, 'A3');
SBYLINE/A150 ='' ; END -* TABLE FILE SETTU1 PRINT SBYLINE ON TABLE HOLD AS SETTUPD1 FORMAT ALPHA END -* -* this html page displays the list created above - but now in 7.7.03 with funny chars. replacing the blanks.
-HTMLFORM QMONUPD1 -RUN
and the hold file has the a with a ' symbol on top. No-one seems to explain why this worked in 7.6.02 but NOT in 7.7.03.
Regards, Ian
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005
Excellent suggestion Tom - worked a treat - changed the NLS code from 437 to 137 in both the Admin Console and the Server Console and all OK now - yippee - Many thanks, Ian
_______________________ *** WebFOCUS 8.1.05M ***
Posts: 196 | Location: London, UK | Registered: December 06, 2005