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     [CLOSED] STRIP FUNCTION FOR TX50 FIELD

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] STRIP FUNCTION FOR TX50 FIELD
 Login/Join
 
Geoff Fish
Platinum Member
posted
I have a challenge I have a field that I need to either remove or translate ' from not sure if its apostrophe or grave but i have never encounterd a field formatted like this before. its a TX50 , I know but that's what the report painter displays.

I started out with strip to no good and also tried CTRAN before I discovered the filed was not in fact an A4000 so any pointers will be appreciated

This message has been edited. Last edited by: FP Mod Chuck,


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
susannah
Expert
posted Hide Post
if its TX50 field, have you tried DEFINE-ing it to an A50 or an A50V and then operating on the /A redefined field?



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
Waz
Expert
posted Hide Post
Yeah, I don't think any function works on a TX field.


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
jgelona
Master
posted Hide Post
Correct me if I am wrong, but TX is just the USAGE format. It says the field is text and display in lines of 50 characters per line. The ACTUAL format is A4000 or maybe even A4000V if it is a field in a relational table. Either way, DEFINE a field as A4000, set it equal to the text field and go from there.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
dhagen
Virtuoso
posted Hide Post
Try using a native DB function in the DB_EXPR function:

RESULT/A4000V WITH xxx=DB_EXPR(some-expression-here);


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Geoff Fish
Platinum Member
posted Hide Post
The master file description says the actual is TX and the usage is TX50

quote:
Originally posted by jgelona:
Correct me if I am wrong, but TX is just the USAGE format. It says the field is text and display in lines of 50 characters per line. The ACTUAL format is A4000 or maybe even A4000V if it is a field in a relational table. Either way, DEFINE a field as A4000, set it equal to the text field and go from there.


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Geoff Fish
Platinum Member
posted Hide Post
Tried that also tried SQL pass thru with dbms_lob.substr(adrconf_comment, 3900, 1)
from alumni.adrconf

still characters showing incorrectly

quote:
Originally posted by jgelona:
Correct me if I am wrong, but TX is just the USAGE format. It says the field is text and display in lines of 50 characters per line. The ACTUAL format is A4000 or maybe even A4000V if it is a field in a relational table. Either way, DEFINE a field as A4000, set it equal to the text field and go from there.


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
jgelona
Master
posted Hide Post
Geoff,

Let me be more specific. In our application we have hundreds of not thousands of small to large, freeform text fields. Everything from 50 characters to 4000 characters. I know this works.

In your master you have a field like this:
  FIELD=TXT01 , LOC_TXT, TX50  , TX    ,$


Now add this to the master:
  FIELD=TXT01V, LOC_TXT, A4000 , A4000 ,$


If you want, could add a DEFINE to the master like this:
DEFINE TXT01V/A4000=TXT01;


Now do your function operations on TXT01V.

Either way should work


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 975 | Location: Oklahoma City | Registered: October 27, 2006Report This Post
Geoff Fish
Platinum Member
posted Hide Post
Sorry that is taken so long to test this I am still not able to get this to work. evin with define in the MFD i have not been able to get either strip, strrep or CTRAN to work.

However as HTML the character renders correctly. could I hold this file in some format and then read? I have even tried SQL passthru and wind up with the same characters.

If someone can tell me how to attache an image to this post ill be glad to do that


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
Francis Mariani
Expert
posted Hide Post
Geoff, dhagen's suggestion should work.

I'm not sure what you're expecting this to do:

dbms_lob.substr(adrconf_comment, 3900, 1) from alumni.adrconf


dhagen's suggestion is to use the relational database native function in a COMPUTE or DEFINE.

For Oracle, it would be:
COMPUTE adrconf_comment_rep/A4000 = REPLACE( adrconf_comment, '`' , '''' );

I'm not sure if COMPUTE adrconf_comment_rep/TX50 would work...


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
Geoff Fish
Platinum Member
posted Hide Post
thanks Francis I will give that a try


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report 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     [CLOSED] STRIP FUNCTION FOR TX50 FIELD

Copyright © 1996-2020 Information Builders