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
Sid

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

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

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)

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

You might try

ON TABLE HOLD AS <filename> FORMAT ALPHA

and then copy or rename your hold file (.FTM) to .TXT.

quote:

now that is an expensive solution

If your maintenance is paid up then it's only time.

time's a constraint..
got to deliver the reports by 18th at most..
thanks anyways..

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 )

T

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 )

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


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