Output file as a text file with tab delimited and fixed length fields

[Former Member]

Hi all,

I have developed a custom report which outputs an excel file on the user desktop who executes that report.Now i need to create an additional (second) excel file with almost the same data as the first file.

Im using the FM GUI_DOWNLOAD to create the file.i need have the 2nd file as txt file(seperated by space/tab delimited) and also i want the fields to have fixed length.For this format of the file,what parameters do I need to pass to the FM ?

BR,

SRM Tech.

[Former Member]

Hi.

Please try.

*-----

Parameter - GUI_DOWNLOAD

WRITE_FIELD_SEPARATOR = 'X'

TRUNC_TRAILING_BLANKS = SPACE

TRUNC_TRAILING_BLANKS_EOL = SPACE

*-----

[Former Member]

Thanks for the prompt reply.

Also in the sel screen,Im entering the path where the o/p file needs to be downloadede.g. C:/Output_folder/Output.xls...Now if I need a text file,do I need to give the fielname as C:/Output_folder/Output.txt.?

[Former Member]

The drive, the folder, and the file name are necessary.

FILENAME = 'C:/Output_folder/Output.txt' "<--- filename