gui_upload

[Former Member]

Hi Experts,

i facing problem while i am uploading text data its special charecters are changing automaticaly as #

but my requirment is as what ever data is maintaned in text file even it is special charectors but it should upload as it is.

so friends how can i stop the these changes.

i am using FM GUI_UPLOAD.

EXMPL

uoploding_text : hi - hello

oputput_text : hi#hello

Thanks & Regards,

Tarun

[Former Member]

Please use a meaningful subject line

[Former Member]

Hi reddy,

My problenm in FM only

that whatever data is in presentation server it not fetching in internal table for special charectors,

its replacing special charecters with #.

so i think subject line is ok.

Regards,

Tarun

[Former Member]

Hello

Try

HAS_FIELD_SEPARATOR = 'X'.

[Former Member]

You will come to know soon friend when the moderator either locks this thread or gives you a warning for your very descriptive subject line

[Former Member]

I dont Thnik so problem in FM , rather in Yourself....

Just use a good subject line.....

one better approach... use offset concept of splting the line of the text file and move that to indivdual fields and append into another internal table..

Regards,

Kumar

[Former Member]

Which subject title do you think is more meaningfull to those who might know the answer:

> 1) gui_upload

or

> 2) FM gui_upload changes special characters to #

or

> 3) Hii experts

or

> 4) None of the above, because it can be searched first.

Just curious...

Cheers,

Julius

[kesavadas_thekkillath]

Wow that was really good !!!

[Clemenss]

Hi Devalla,

OK, better subject next time.

Special characters are not replaced by but displayed as #. Just because you can not display them.

Regards,

Clemens

[Former Member]

Solved my self

[Former Member]

HI,

Please share the answer .

regards,

ShaiKSHadulla.

[Former Member]

I think "Solved my self" means that the fields of Tarun's internal table were of type "banana peel"...

[kesavadas_thekkillath]

))))))))))))))

[Former Member]

Considering GUI_UPLOAD's innocence here, perhaps GUI_SLIP would have been an OK subject title

[Former Member]

Hello Friends,

I had a problem with GUI_UPLOAD, that i am getting junk values or # sign after every field. I was going through these thread and did not find answer in it. But i solved this my self. Then thought of sharing to everybody.

1) First convert Excel to Tab delimeted (*txt)

2) Then

CALL METHOD cl_gui_frontend_services=>gui_upload

EXPORTING

filename = iv_file_name

filetype = 'ASC'

has_field_separator = 'X'

IMPORTING

filelength = lv_length

CHANGING

data_tab = lt_customers

Please copy paste the same. otherwise if you keep commented fields like REPLACEMENT = '#' you will get error in this .

So keep only

filename = iv_file_name

filetype = 'ASC'

has_field_separator = 'X'

Rest everything just delete.

Hope it will help for others who facing problem in uploading excel.