 |
|||||
|
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| comparison on alpha field | Login/Join |
| Silver Member |
I'm trying to run a report breaking down pc's by the departments they are in. This is determined based upon their IP. The IP field is considered text. I have attempted to change this field to numeric in the master data file. My define is DEPARTMENT/A10= IF IP GE '10.100.1.31' OR LE '10.100.1.254' THEN 'PFM' ELSE IF IP GE '10.100.9.31' OR LE '10.100.9.254' THEN 'DATA' ELSE 'OTHER'; If I do it as listed above I get the error COMPARISON BETWEEN COMPUTATIONAL AND ALPHA VALUES IS NOT ALLOWED If I take off the quotes around the IP address I get an error FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: 10.100.1.31 Am I going to have to do a computation into binary number or something in order to do this define? | ||
|
| Guru |
Take a look at the EDIT function. | |||
|
| Guru |
Here is a doc I found on the tech support site: http://documentation.informationbuilders.com/masterinde.../08sa07.htm#08sa13_3 | |||
|
| Silver Member |
thank you | |||
|
| Expert |
Ginny, You cannot change the IP address field to numeric - it has several dots in it. Your syntax for the IF statement is incorrect. IF IP GE '10.100.1.31' OR LE '10.100.1.254' THEN 'PFM' is wrong. These are correct: IF IP GE '10.100.1.31' OR IP LE '10.100.1.254' THEN 'PFM' or IF IP FROM '10.100.1.31' TO '10.100.1.254' THEN 'PFM' Cheers, Francis. 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 | |||
|
| Silver Member |
I'm using the Edit function and just pulling out the 3rd octect, since that's what I need. Unfortunately not all the IP's are exactly the same so my edit that says IPADD/I2= EDIT(IP, '$$$$$$$99$$$$') works fine for an IP that is 10.100.25.111 but doesn't work for one that is 10.1.1.154 any idea how to deal with that? | |||
|
| Silver Member |
Francis, Your suggestion of the FROM and TO worked. Thanks again for everyone's help | |||
|
| Expert |
I would transform the IP addresses - separate the four parts, add leading zeros, put the parts back together and then test. 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 | |||
|
| Guru |
You can also use the GETTOK to pull out the each part of the IP. | |||
|
| <Special-K> |
Also when comparing '10.100.1.31' to '10.100.1.254' remember '10.100.1.31' is GREATER than '10.100.1.254' since that is a string comparison. | ||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 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 |