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] Removal of two Spaces at the starting of the rows

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Removal of two Spaces at the starting of the rows
 Login/Join
 
sidney_jec
Member
posted
Hi

i am having the following code (for illustration purposes):
DEFINE FILE CAR
CAR_DETAILS/A100 = COUNTRY|' '|CAR|' '|MODEL|' '|BODYTYPE;
END
TABLE FILE CAR
PRINT
CAR_DETAILS
BY MODEL

END
-RUN


Now i want to burst this report by "model" and the output I want is a .txt file. But I also don't want the 2 spaces that come in the starting of the row.

I tried using WP format but the spaces are still there. Also reportcaster doesn't allow me to burst the report in CSV or ALPHA formats.

Is there any other format/way through which I can do this?

Thanks in advance Smiler
Sid

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


_________________________________________________________________

WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java
Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP
WF Client: 7.1.4 on Windows 2K3 w/Tomcat
 
Posts: 27 | Registered: August 12, 2009Report This Post
Håkan
Guru
posted Hide Post
What about this?

APP HOLD REDOR
DEFINE FILE CAR
CAR_DETAILS/A100 = COUNTRY|' '|CAR|' '|MODEL|' '|BODYTYPE;
END
TABLE FILE CAR
PRINT
CAR_DETAILS
BY MODEL
ON TABLE HOLD FORMAT WP
END
-RUN
-SET &LINE = ' ';
APP FI HOLD2 DISK redor/hold2.txt
-RUN
-:read
-READ HOLD &LINE.A102.
-IF &IORETURN NE 0 GOTO :endread;
-SET &LINE2 = SUBSTR(&LINE.LENGTH,&LINE,3,102,100,'A100');
-WRITE HOLD2 &LINE2
-GOTO :read
-:endread
-RUN


WebFOCUS DS 8.0.06/08 DS/AS
WebFOCUS RS 8.0.08 (Linux/IBM i)
WebFOCUS Client 8.0.06 (Linux)
 
Posts: 319 | Location: Stockholm, Sweden | Registered: February 04, 2004Report This Post
<JG>
posted
You need to upgrade,

Bursting of FORMAT COMMA, COMT, TAB and TABT is supported in version 7.6.x

(documented in 7.6.1 and up manual but I can't remember in which x it was a new feature)
 
Report This Post
sidney_jec
Member
posted Hide Post
quote:
Originally posted by H Lidholm:
What about this?


wel i have to burst the report.
I can generate the file otherwise ie without spaces in Alpha format.

quote:
Originally posted by JG:
You need to upgrade,

Bursting of FORMAT COMMA, COMT, TAB and TABT is supported in version 7.6.x

(documented in 7.6.1 and up manual but I can't remember in which x it was a new feature)


now that is an expensive solution Big Grin


_________________________________________________________________

WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java
Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP
WF Client: 7.1.4 on Windows 2K3 w/Tomcat
 
Posts: 27 | Registered: August 12, 2009Report This Post
Dan Satchell
Virtuoso
posted Hide Post
You might try 
ON TABLE HOLD AS <filename> FORMAT ALPHA
and then copy or rename your hold file (.FTM) to .TXT.


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
<JG>
posted
quote:
now that is an expensive solution

If your maintenance is paid up then it's only time.
 
Report This Post
sidney_jec
Member
posted Hide Post
time's a constraint..
got to deliver the reports by 18th at most..
thanks anyways..


_________________________________________________________________

WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java
Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP
WF Client: 7.1.4 on Windows 2K3 w/Tomcat
 
Posts: 27 | Registered: August 12, 2009Report This Post
Tony A
Expert
posted Hide Post
quote:
Also reportcaster doesn't allow me to burst the report in CSV or ALPHA
Then don't use report caster, use something that will allow you to send emails with attachments in the format that you want, such as CDONTS.

Don't ask for examples though because then we'll know that you don't search for stuff (hint) and just wait for someone to do the work for you!

Of course, if you want to have consultancy then my rates are reasonable (although Francis is bound to say he's cheaper Wink)

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: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
sidney_jec
Member
posted Hide Post
quote:
Originally posted by Tony A:
[QUOTE]
Don't ask for examples though because then we'll know that you don't search for stuff (hint) and just wait for someone to do the work for you!

Of course, if you want to have consultancy then my rates are reasonable (although Francis is bound to say he's cheaper Wink)

T


FIRST OF ALL THANKS FOR THE SUGGESTION..

your second thing though doesn't make sense.
see i had told you the constraints in the beginning itself that I have to use bursting AND I have to use report caster as well. I tried everything possible with the current version of Webfocus. Plus I never asked for a hint. Rather I had asked for a solution itself. and these are what this forum basically is in the very first place..or isn't it??

Now I had tried everything possible and couldn't get to a solution thats why I had put up the query here..

try and search for the particular topic I have posted. If you don't have a solution don't reply..thats it..as simple as that..
but then again you can reply (oh yes i know you don't need my freakin permission)..we are no autocrats here right Wink


PS: I am now using a Perl script to remove the spaces from all the files.


_________________________________________________________________

WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java
Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP
WF Client: 7.1.4 on Windows 2K3 w/Tomcat
 
Posts: 27 | Registered: August 12, 2009Report 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] Removal of two Spaces at the starting of the rows

Copyright © 1996-2020 Information Builders