topic Re: Downloaded Text file format issue in Application Development and Automation Discussions

Downloaded Text file format issue

former_member210804 — Thu, 24 Sep 2015 08:17:55 GMT

Hi Experts,

I have download a text file with header and data. But it was not coming proper format like excel sheet where the data comes with corresponding column header. Could you please let me know how can i achieve it?

In the below screen, the headers are not in proper position.

Best regards,

Narasimha.

Re: Downloaded Text file format issue

rosenberg_eitan — Thu, 24 Sep 2015 08:35:55 GMT

Hi,

How the end user is going to view the file ?

If you will use CSV format then Excel will do the alignment for you.

Have a look here:

Regards.

Re: Downloaded Text file format issue

former_member210804 — Thu, 24 Sep 2015 11:43:17 GMT

Hi Eitan,

I have a requirement for text file with proper alignment same like how we get in excel sheet . Could you please tell me how we can do it?

Best regards,

Narasimha>

Re: Downloaded Text file format issue

RaymondGiuseppi — Thu, 24 Sep 2015 12:05:28 GMT

You could have fun to align the titles giving them the same length as the data fields ... But what will happen if (when) a user changes his notepad options to use a non-proportional font...

Regards,

Raymond

Re: Downloaded Text file format issue

rosenberg_eitan — Thu, 24 Sep 2015 12:48:20 GMT

Hi,

I did not think about this one.....

Regards.

Re: Downloaded Text file format issue

rosenberg_eitan — Thu, 24 Sep 2015 13:01:29 GMT

Hi,

Have a look at the "WRITE" or "WRITE TO" commands additions.

[pos][(len)]

[LEFT-JUSTIFIED|CENTERED|RIGHT-JUSTIFIED]

You can use those to write to data set or a character variable .

Regards .

Re: Downloaded Text file format issue

Former Member — Thu, 24 Sep 2015 13:21:35 GMT

Hi narasimha,

This is purely aligned.

what I mean is, all the fields in the header and data are separated with a single tab.

But if you want them to be aligned like given below

PERNR BEGDA ENDDA

012003 01.01.2008 31.01.2015

Then please use same length for all the data fields.

That means, the header label 'PERNR', 'BEGDA' and 'ENDDA' should be saved in the internal table with the same data type so that the labels and the data all have same length.

Re: Downloaded Text file format issue

former_member809980 — Thu, 24 Sep 2015 15:39:00 GMT

hi,

fm GUI_DOWNLOAD itself align the headers and the data.

please refer the following code..

w_header-text = 'Sales Document'.

APPEND w_header TO it_header .

CLEAR w_header.

w_header-text = 'Message Type'.

APPEND w_header TO it_header .

CLEAR w_header.

w_header-text = 'Message'.

APPEND w_header TO it_header .

CLEAR w_header.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = lv_file

filetype = 'ASC'

write_field_separator = 'X'

show_transfer_status = 'X'

TABLES

data_tab = it_data

fieldnames = it_header

hope this will help..