 |
|||||
|
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
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 WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Displaying the Greater-than-or-less-than symbol
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Displaying the Greater-than-or-less-than symbol Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Displaying the Greater-than-or-less-than symbol | Login/Join |
| Platinum Member |
Hello all, I have a report that requires me to display the symbol for "greater than or equal to" and "less that or equal to". I am attempting to use the function "HEXBYT" to convert the decimal representation to the sysbols, however when I use 8804 and 8805 , which is what the web says is the decimal representation for these fields, get different values. Does anyone have any sugestion: DEFINE FILE CAR CR/A2 = HEXBYT(8805, 'A2'); END TABLE FILE CAR PRINT MODEL CR END ThanksThis message has been edited. Last edited by: tlbrydie2, Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC | ||
|
| Expert |
| |||
|
| Platinum Member |
Tom: 60 and 62 worked..but the results are < and >, I'm looking for the symbolic representation for "greater than or equal to" and "less that or equal to" which from my understanding are 8804 and 8805 but this is not returning the right symbols Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC | |||
|
| Expert |
Tim, Is this the representation you are looking for?
DEFINE FILE CAR
CR/A2 = IF COUNTRY IN ('JAPAN','ENGLAND') THEN HEXBYT(60, 'A1')|| HEXBYT(61, 'A1') ELSE
HEXBYT(61, 'A1')|| HEXBYT(62, 'A1');
END
TABLE FILE CAR
PRINT
MODEL CR
END
Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Expert |
Tom, according to tlbrydie2's sig, his platform is Windows. You don't need HEXBYT for these characters - they're on the keyboard, so CR/A2 = '>=';works. tlbrydie2's looking for ≥ which I can't seem to get to display with HEXBYT. For HTML only, this ≥gives you ≥. Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
AHH! Thanks Francis. I almost put your CTRAN link up, but, thought better of it. Well, it's always doable via an image... Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Platinum Member |
Tom and Francis, Thanks very much for taking time in your day trying to assist me. I don't seem to be getting the right results, I wanted to exhaust all possibilities, before I went back to the client and told them WF could not handle this. I'm looking at one other thing..but thanks allot for both of your help. Timothy Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC | |||
|
| Expert |
Well, I never give up - How about this:
DEFINE FILE CAR
CR/A1 = IF COUNTRY IN ('JAPAN','ENGLAND') THEN HEXBYT(60, 'A1') ELSE HEXBYT(62, 'A1');
END
TABLE FILE CAR
PRINT
MODEL CR
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N2, STYLE=NORMAL+UNDERLINE, JUSTIFY=CENTER,$
ENDSTYLE
END
-EXIT
Works in HTML and EXCEL, also... Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Expert |
Very inventive! Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
Tom, That was a very creative solution...it just might be acceptable to the client. Why did'nt I think of that1! :-) Thanks allot, Timothy Prod: WebFOCUS 7.6.10 MRE Oracle/Sybase Test: DevStudio 7.6.6 WF Server 7.6.6 Report Caster 7.6.6 Web Server - Tomcat MS Windows XP SP2 Output: HTML, Excel 2000 , PDF, CSV, DOC | |||
|
| Expert |
Thanks to both of you, and, hope it works for the "client". Every once in a while, it's good to be creative, even though, as Francis stated earlier, don't need HEXBYTE, just the '>' or '<' test... Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Virtuoso |
Good job Tom. Always hate to see someone say something can't be done in WebFocus...there is usually a way! | |||
|
| Expert |
THANKS Linda! Hope all is well with you in San Antonio Texas... Tom Flynn WebFOCUS 8.1.05 - PROD/QA DB2 - AS400 - Mainframe | |||
|
| Virtuoso |
Enjoying Spring! | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Displaying the Greater-than-or-less-than symbol
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Displaying the Greater-than-or-less-than symbolCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |