Regarding uploading data from .CSV file to internal table

[Former Member]

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.

[Former Member]

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.

[Former Member]

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]

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]

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.