Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Converting HexCode
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Converting HexCode
 Login/Join
 
Member
posted
Good morning. I am not a programmer but I use webfocus to design and created basic reports. One of the issues that I am having is that I need to convert data from hex to decimal. In excel, I can convert back and from using hex2dec or dec2hex. What I have, for example, is 4D01A443 (hex) that I need to convert to 1291953219 (dec) so that I can join two tables to create a report. The "userid" in one table is the hex code but in the 'user' table the "userid" is a dec code.

Any suggestions?

Thanks,

Scott

This message has been edited. Last edited by: FP Mod Chuck,
 
Posts: 2 | Registered: December 27, 2019Reply With QuoteReport This Post
Virtuoso
posted Hide Post
https://infocenter.information...source%2Ftopic13.htm

Probably need UFMT function.


WebFOCUS 8206, Unix, Windows
 
Posts: 1822 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Expert
posted Hide Post
What version of WebFOCUS are you on ?

There are new functions being added in new releases.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6252 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
WebFocus Enterprise Edition
Product Release: 8.2
Service Pack: 0.1
Build/GEN Number: 164
Build/GEN Date: May 5, 2017

thanks,
 
Posts: 2 | Registered: December 27, 2019Reply With QuoteReport This Post
Expert
posted Hide Post
You should put that in your signature, under Go / Personal Zone / Profile / View/Edit Complete Profile

Then add it to "(**required) Product Signature: Please fill out your WebFOCUS release, OS/Platform, and expected Output format(s), AND also the fields below:"

You can use HTML in it.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6252 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
I'm beginning to this that there are two ways to do this.

1. Write something, say a DEFINE FUNCTION that converts each char of the string to a number, then multiplying them out to get the integer. I think I've done that before, a long time ago.

2. If you are calling a relational DB, you could use DB_EXPR to call a native DB function like CONVERT or CAST


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6252 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
quote:
Any suggestions?

Yes, shoot or re-educate the designers of your tables! This should never be designed this way!

Seriously though, There are some good suggestions here. Also consider doing a search on the forum for "HEX TO DEC" as this question has been asked (and answered) before, so you may find other suggestins in previous answers.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5661 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Converting HexCode

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.