Eliminate blank line from the end of the file

[Former Member]

Hi All,

I am downloading a file in the local drive using f.m 'Download' in txt format. A blank line is getting inserted at the end of file .

please suggest how to delete the blank line.

Thanks

[Former Member]

Hi ,

Before downloading it into local server using function module , are you passing the values to an internal table, if so then delete the blank line before passing it through function module. The deletion is poissible by passing the internal table through loop.

Try and let me know.

Thanks,

Vengalrao

[Former Member]

Thanks for the response , but there is no blank line in the internal table

[former_member193284]

Hi Neha,

Do you have '#' value at the end of the records in your file or internal table? if yes this inserts a new line. Please check this as well..

Thanks

[Former Member]

Hi Sumit,

I am appending a right arrow sign at the end of the file which is stored as # in my internal table, but even if I remove this right arrow from my file, i still get the blank line in my downloaded text file

[former_member193284]

Hi Neha,

Can you try to open the file and do control 'A' (Select all records) and see if you have a blank line at the end of the file.

Thanks

[Former Member]

Hi Sumit,

If I open with word pad , the blank line is also selected. For your reference this is the downloaded file with the end of file indicator

A;N;00000000244800;10;PLSM-C16/1N-DW;Miniature Circuit Breaker;1;0;ST;1500;20;20;00000001;

B;N;00000000244800;PLSMC161NDW;Miniature Circ; ;0;0;0;4015082448004; ;X;0;; ; ;

Thanks

[former_member193284]

Hi Neha,

Ensure you dont have a blank line in the file. Either keep the cursor at the end of the last line and save the file again.

Or delete the last line by selecting it. when your uploading ensure you dnt have any blank line at the end of the file.it will be appended as a blank record in ur internal table

Thanks

[Former Member]

Thanks for the responses,

there is no blank line in my internal table. Also, user won't be deleting the blank line manually from the file and then save it. I blank line should not be there in the downloaded file.

[Former Member]

Hi Neha,

Use FM GUI_DOWNLOAD

and try with the following parameters in the import

TRUNC_TRAILING_BLANKS = 'X '

WRITE_LF = ' '

TRUNC_TRAILING_BLANKS_EOL = 'X'

WRITE_LF_AFTER_LAST_LINE = ' '

[Former Member]

Hello Kash,

I am working in 4.6C and need to do it for a particular file type 'IBM' and 'GUI Download' doesn't support this file format.

[former_member195402]

Then You can use FM "WS_DOWNLOAD".

Regards,

Klaus

[deepak_dhamat]

hi ,

Then You can use FM "WS_DOWNLOAD".

Dont use ws_downloan it is OBselete , it will give error during Unicode convwerison from 4.7 to ecc 6.0

Try something different .

Regards

Deepak .

[former_member195402]

Sorry Deepak,

you're wrong, WS_DOWNLOAD is not obsolete in 4.6C, I just have looked before posting in our 4.6C system, and it supports the demanded file format!

Regards,

Klaus

[deepak_dhamat]

HI ,

TRY USING ,

CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
FILENAME = 'C:\BARCODE\CODE.PRN'
FILETYPE = 'IBM'
TABLES
   DATA_TAB = ITAB1.

Regards

Deepak.

[deepak_dhamat]

hi ,

Read Documentation .

there are lots of function module which are there in 4.6 , which also works fine but sap

has not recomended to use as they are goin to remove it from further version ..

so it is always better to use GUI_download ....

we are now into ECC 6.0 ffrom 4.7 where testing is going on .

i have just replaced all ws_download , ws_upload by gui_upload and gui_download due to unicode conversion .

i AM Not proving you right or wrong , giving just information which might help you further .

Regards

Deepak.

Edited by: Deepak Dhamat on Oct 15, 2010 9:33 AM

[Former Member]

Dear Deepak,

In 4.6 C GUI_Download gives a dump if u use any othe file type then 'BIN' and 'ASC'.

For your reference

• Filetype parameter valid ?

CASE filetype.

WHEN 'BIN' OR 'ASC'.

WHEN OTHERS.

RAISE INVALID_TYPE.

ENDCASE.

Thanks and Regards

[former_member195402]

Hi,

did you check FM "WS_DOWNLOAD"?

Regards,

Klaus

[Former Member]

Thanks for your responses,

WS_Download doesn't solve the problem of eliminating blank line

[deepak_dhamat]

Hi Neha ,

In 4.6 C GUI_Download gives a dump if u use any othe file type then 'BIN' and 'ASC'.

Actually it should not , because

go to se37 -> give -> GUI_Download ->

Press F7 or display you will find this code in it .

• Filetype parameter valid ?

CASE prc_filetype.

WHEN 'BIN' OR 'ASC' OR 'DAT' OR 'DBF' OR 'WK1' OR 'VSS'. "--- New: VSS Format (JB/07-2006)

WHEN 'IBM'.

prc_filetype = 'ASC'.

prc_codepage = '1103'.

WHEN OTHERS.

MESSAGE ID 'FES' TYPE 'E' NUMBER '004' RAISING INVALID_TYPE.

ENDCASE.

this may be due to 4.6 otherwise in 4.7 i.e patch no 31 it should be there .

if it is not there then you need to try something different .

CHECK THIS CLASS "CL_GUI_FRONTEND_SERVICES"  .

regards

Deepak.

Edited by: Deepak Dhamat on Oct 15, 2010 12:58 PM

[deepak_dhamat]

hi neha,

Check this Link

ask Suhas .... Regarding this he might help you to go on correct Path for your problem .

Regards

Deepak.

[Former Member]

Hello Deepak,

Thanks for your quick responses. are you aware of any other function module which resolves the problem of blank line apart from GUI_DOWNLOAD which I can use in 4.6C

[deepak_dhamat]

Hi neha ,

If gui_download does not solve your problem , then there is only one option

try saving data in another format which will not have blank line at the end .

Otherwise you have to Fight all alone ....

because i have seen efforts of all experts you have replied you with there solution .

Still wait if any one might have experienced this kind of problem .

Regards

Deepak.

[former_member195402]

Hi,

FM DOWNLOAD is out of date, can You use FM GUI_DOWNLOAD for this? Is the problem still remaining?

Regards,

Klaus

[Former Member]

keep the cursor right next to lastline in the file.if you keeping the cursor below the lastline it might taking it as new line and appending empty line.

[deepak_dhamat]

Hi Neha ,

you can read Documentation for GUI_download ,

when you want IBM File type , then Gui_download function module

then changes it internally Codepage ='1103 ' and filetype='ASC'

WHEN 'IBM'.

prc_filetype = 'ASC'.

prc_codepage = '1103'.

Regards

Deepak.

[Former Member]

Hi All,

I've tried WS_DOWNLOAD also and am still getting the blank line. I need to suppress this blank line in the txt file downloaded. Kindly suggest any other function module or method to suppress the blank line.

Thanks

[Former Member]

Hi Madam,

you should use OO concept, pls use CL_GUI_Frontend Service method....

Your prob will get resolved...

if you want the code then provide me the email.

Thanks,

Prarthan.

[Former Member]

Inserted the EOF character