Hi All,

Please help me with this.
I have a text file which I created using WP format and it is sent to user through report caster as a .txt file. User wants that file to have a message "END OF FILE" as last line, issue is that this message should start from column 1 of the file whereas WP format inserts 2 spaces in beginning of each record.
Please reply if you think of any solution.

Thanks!

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

There is a recent (last 2-3 weeks) post that talks about prepending and appending rows to a file. Write your end of file record to a separate file and attach it to your main file. You can use any number of techniques to do this, operating system commands, alternate masters and MORE, etc.

If you can't find the post, let me know and I'll try to find it for you.

Hi
This link discusses how to remove the form feed/page-break character from FORMAT WP

http://techsupport.information...om/sps/12702105.html -

To append at the end of the file- this is one technique

TABLE FILE CAR
PRINT CAR BY COUNTRY
ON TABLE HOLD AS HOLD01
END
-RUN
FILEDEF HOLD01 DISK C:\path\HOLD01.FTM (APPEND <-- issue APPEND
-RUN
-SET &VALUE='END RECORD RECORD';
-WRITE HOLD01 &VALUE

Good Luck,
Rhonda

Thank you Ginny and Rhonda. I got it resolved by appending the message to the last line of file.
Thank you so much.