topic Re: problem with character '#' and function gui_download in Application Development and Automation Discussions

problem with character '#' and function gui_download

jeanclaudelhote — Thu, 22 Dec 2005 14:05:45 GMT

Hi,

i use the function gui_dowload to download an internal table into a pc file

in my table there is a text field with sometimes the character '#'. when this character is in the description

we have a carriege return in the file, but it happens only in one machine (quality) and not in developpment..

very strange ??

has someone got an idea please ??

thanks in advance

Re: problem with character '#' and function gui_download

andreas_mann3 — Thu, 22 Dec 2005 14:20:15 GMT

Hi,

i think, there must be different operating systems

and/or different code pages.

-> so experiment a very little with abap command:

translate wa to code page <b>TCP00</b>-CPCODEPAGE.(look f1)

Andreas

Re: problem with character '#' and function gui_download

Former Member — Thu, 22 Dec 2005 15:28:22 GMT

Before you download using gui_download , pass the data through this FM SSM_REPLACE_CHAR_BY_HEX_VALUE

. It will solve the problem.

Regards

Kalpana

Re: problem with character '#' and function gui_download

Former Member — Thu, 22 Dec 2005 15:51:20 GMT

Hey Jean,

I got your Point, Please check the FM Used in the Development System & Quality System also There might be some chances like while sending the Patches somebody might have changed the Parameters, if you were using the Exporting Parameters like File Type(Exporting paramter0 as 'ASC' and the write_field_sepeartor is equal to space. then it will be Padded with '#' While Downloading. When ever you are the File Type(Exporting Parameter) as 'ASC', you should see the Write_field_seperator(Exporting Parameter) is equal to '#'.

Please let me know, If you were not able to solve this, I will give you another solution, Which really Helps you a lot.

Thanks,

Satya Krishna.M

Re: problem with character '#' and function gui_download

Former Member — Thu, 22 Dec 2005 16:39:18 GMT

Hi,

Pass the following

v_filtyp = 'ASC'.

v_separator = cl_abap_char_utilities=>horizontal_tab.

call function 'GUI_UPLOAD'

EXPORTING

filename = File name

filetype = v_filtyp

has_field_separator = v_separator

TABLES

data_tab = itab

EXCEPTIONS

file_open_error = 1

file_read_error = 2

no_batch = 3

gui_refuse_filetransfer = 4

invalid_type = 5

no_authority = 6

unknown_error = 7

bad_data_format = 8

header_not_allowed = 9

separator_not_allowed = 10

header_too_long = 11

unknown_dp_error = 12

access_denied = 13

dp_out_of_memory = 14

disk_full = 15

dp_timeout = 16

others = 17.

Thanks

Rajeev

Re: problem with character '#' and function gui_download

Former Member — Fri, 23 Dec 2005 06:36:48 GMT

Hi Jean,

1. finally what u want the output to be in text file.

Should the output be with carriage return

as :

THIS IS LINE1

AND THIS IS LINE 2.

2 OR (without carriage return)

THIS IS LINE1 AND THIS IS LINE 2.

regards,

amit m.

Re: problem with character '#' and function gui_download

jeanclaudelhote — Fri, 23 Dec 2005 08:35:33 GMT

Thanks to all for your informations

we have two operating systems and it works fine with one of them and not fine with the other, so our administrator will check the parameters of the second operating systems to see the difference..

in parallel, i will try to implement abap corrections..

Re: problem with character '#' and function gui_download

Former Member — Fri, 12 Mar 2010 14:27:55 GMT

Hi All,

try to login system with your language

regards

Re: problem with character '#' and function gui_download

Pranay_Panchbha — Sat, 13 Mar 2010 10:57:57 GMT

there is no any problem

just drag the excel sheet column and incresed the lenghth of it it automatically sort ur problem

Edited by: pranay panchbhai on Mar 13, 2010 4:28 PM