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     WebFocus documentation

Read-Only Read-Only Topic
Go
Search
Notify
Tools
WebFocus documentation
 Login/Join
 
Majid Jeddi
Guru
posted
Hi,

I am trying to use the PARAG function in one of my reports.
According to the documentation, this function is supposed to create from one field many lines.
I am surprised to see the result on the same line with the separator i have specified.
Is this a bug or I am doing something wrong.

Can you help?

Rgards


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report This Post
GamP
Virtuoso
posted Hide Post
Majid,
This is not a bug, but it works as intended.
The PARAG routine is used to divide large pieces of text into smaller parts, separated by a separator of your choice. The rsult is as you found, a single field with the original text, now containing your separators. Next you can (should) use GETTOK to actually get the smaller pieces of text one by one from the result of PARAG.


GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Majid Jeddi
Guru
posted Hide Post
Hi Gamp,

Thanks for your reply.
Since the field I am working with is long, I was expecting these functions to split it to many lines and display them one under the other:

Ex: Line =aaaaaaaa,bbbbbbb,cccccc

I was Expecting this:

aaaaaaaa
bbbbbbbb
cccccccc

Note: I am creating the report in MRE.

Thanks


WebFocus 7.6.5
AND WebLogic server as web server
sql2005 as database server
 
Posts: 273 | Location: Europe | Registered: May 31, 2007Report 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     WebFocus documentation

Copyright © 1996-2020 Information Builders