Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding uploading data from .CSV file to internal table

Former Member
0 Kudos

Hi all,

For uploading data from .CSV file to internal table am using function module GUI_UPLOAD where am passing parameters filename= file_str and filetype ='ASC' and for browsing file am using F4_FILENAME.

The problem i am facing is that data outputed on the screen is in some different format as like this :

Ð #### ## #©.##.#### ##.##.#### 00 ###õÿ 000000000 ###;_(@_) ###;_(@_) }#A#} ###; ###;_(@_) }#A#}######### # ## ##########ÿ###### ### ####

0000000000000 ## efýéÙÿ###########ÿ ÌLüÕ´ÿ#### 23úÀ#ÿ###### ##÷#Fÿ########ÿÿÿÿ%##### ####ÿ#####ÿ######*####Check Cell##################

0000000000000 0000000000005 Go.##.#0## ##Heading #H# ##H

Can anyone help me to solve this issue.

Thanks,

Jay.

3 REPLIES 3

Former Member
0 Kudos

Hi Jay,

u can save the .csv file in a .txt file and upload it .

using file type = 'BIN'.

hope this vll solve ur problem.

and if u are using ASC filetype then mention the feild separator

and split the feilds at the separator into the internal table columns

regards

venkat.

Edited by: venkat sharma gaddala on Jun 8, 2009 11:21 AM

Former Member
0 Kudos

Hi,

If you are using 'ASC' FILETYPE then also mention

HAS_FIELD_SEPARATOR = ' X ' (default is ' ') in the gui_upload function module.

Hope this will solve your problem.

With Best regards,

Pulak

umashankar_sahu
Active Participant
0 Kudos

hi jay

with suggestion of venkat and pulak you just take care in case of function module F4_FILENAME file type is of type Rlgrap-filename which is of type char but in case of function module GUI_UPLOAD file type is of type string.

or you can save your local file in .txt (word pad or notepad) format and then try to upload .

may be this is helpfull for you.