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     [SOLVED] What happened to EDIT()?

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] What happened to EDIT()?
 Login/Join
 
Wep5622
Virtuoso
posted
We used to do stuff like below, using EDIT to format date output:
TABLE FILE CAR
PRINT CAR
	COMPUTE I/I8 = 20121230;
	COMPUTE A/A7 = EDIT(I, '9999/99');

BY COUNTRY
END


Prior to WF77 this would return values in A as '2012/12'.

However, with WF77 these values are returned as '2012///'!

Is that intentional? If so, why is that?

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


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Francis Mariani
Expert
posted Hide Post
I get "2012/12" in v7.7.03.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Vivian
Platinum Member
posted Hide Post
quote:
COMPUTE A/A7 = EDIT(I, '9999/99');


Well, I am on 7.7.03 and get the same result as Wep - had to do this to get it right:
COMPUTE I/I8 = 20121230;
-*** this worked
COMPUTE AP/A7 = EDIT(I, '9999')|'/'|EDIT(I,'$$$$99');


Vivian Perlmutter
Aviter, Inc.


WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

 
Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Same here on my 7.7.03.
Try the following:
  
TABLE FILE CAR
PRINT CAR
	COMPUTE I/I8 = 20121211;
	COMPUTE B/A7 = EDIT(I, '9999/99');
	COMPUTE A/A7 = EDIT(EDIT(I, '999999'),'9999/99');
BY COUNTRY
END


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
Waz
Expert
posted Hide Post
I tried in 7.1.6 (Unix), 7.6.6 (Unix), 7.6.11 (Unix) and 7.7.03 (Win) and all worked.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
nd
Silver Member
posted Hide Post
We're on 7.7.03, HotFix 6 (might as well be specific).

It worked.


WF: WebFocus 7.7.03
Data: Oracle, MSSQL, DB2
OS: Windows
Output: HTML/AHTML,PDF,EXL2K FORMULA, COMT
 
Posts: 43 | Registered: November 21, 2011Report This Post
Wep5622
Virtuoso
posted Hide Post
Vivian, that is how I already worked around the issue to fix the problem for our customer. I was just wondering whether what I saw was expected behaviour. Apparently it's not.

nd, our WF client is on 7703 Hotfix 6 as well. Our server is 7704 though, might that be the difference?

Another possibility, our WF client & server are on a 64-bit OS. Perhaps there's a bug that shows up there that doesn't show on 32-bit systems?

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


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Danny-SRL
Virtuoso
posted Hide Post
WORKS at customer site 7.7.02


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
susannah
Expert
posted Hide Post
you're editing an Integer with a map that works on an Alpha
if you just fix that /I8 concept, you should be fine.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
nd
Silver Member
posted Hide Post
quote:
nd, our WF client is on 7703 Hotfix 6 as well. Our server is 7704 though, might that be the difference?


It might be the server versions. It might also be a big load of frustrating.

If you haven't opened a support ticket, it might be worth it, to save someone else the bug down the line.


WF: WebFocus 7.7.03
Data: Oracle, MSSQL, DB2
OS: Windows
Output: HTML/AHTML,PDF,EXL2K FORMULA, COMT
 
Posts: 43 | Registered: November 21, 2011Report This Post
Francis Mariani
Expert
posted Hide Post
Well, even though the code worked for me, susannah is right - the code is doing two things at once - converting from integer to alpha and also embedding a slash - this should be done in two steps.

This message has been edited. Last edited by: Francis Mariani,


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Waz
Expert
posted Hide Post
I do agree as well. If this is a loophole, then it may well disappear during code tightening in the future.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Wep5622
Virtuoso
posted Hide Post
Oh dear, we use EDIT to do precisely this all the time! Apparently, an IBI consultant taught us to do conversions from integer to alpha just like this.

If that behaviour has changed, we're looking at a fairly serious backwards compatibility issue. I'll open a case.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Edward Wolfgram
Gold member
posted Hide Post
Wep, your code is perfectly fine and should produce 2012/12. You are doing a numeric edit with mask and this has been supported forever. Opening a case with CSS should solve this problem for you, which may be some environmental issue- it may be windows specific.


IBI Development
 
Posts: 61 | Registered: November 15, 2005Report This Post
Wep5622
Virtuoso
posted Hide Post
Server 7704M Gen 773 (such a confusing gen-number!) fixed the issue.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
 
Posts: 1669 | Location: Enschede, Netherlands | Registered: August 12, 2010Report This Post
Francis Mariani
Expert
posted Hide Post
Well, I guess some of us were being too strict about the code.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report 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     [SOLVED] What happened to EDIT()?

Copyright © 1996-2020 Information Builders