Uploading a file

[Former Member]

Hi All,

I have a table that has around 50,000 records, I want to download that table and when I tried to download it as a flat file... it did download but the data is separated by "|" but I want data to separated by "," and then I need to upload the comma separated file using a program to a custom table. So can you please tell me how can I do that.

Thanks,

Rajaeev

[former_member376453]

Go to that file, use ctrl + H and replace the "|" with ","

Kuntal

[Former Member]

I tried this but it's not working may be because of huge data

[Former Member]

Hi,

I dont think its possible to download or upload a file with a separator as comma.

if you want you can Try it out with small amount of data from the table also, you will still not get comma aws a separator,

because by default SAP has only two separators for download or upload of a flat file that is , TAB and a single SPACE... if you mention anything for separator it is considered to be a tab and if you dont mention anything in the separator it is considered to be a space.

Regards,

Siddarth

[former_member156446]

see in the program where '|' has been defined, replace it with ','...

to have data save to custom table.. have all the records into an internal table and use modify DBTAB from itab. DBTAB and itab need to be exactly same structures.

[former_member376453]

When you are downloading fro table through SE16, by default it comes with.xls, make it .csv and give your name. suppose this is test.csv , if your program is able to open a excel then it will work. If your input should be a text file then open your test.csv with notepad and save it as test.txt. and try to upload this. May be this should work.

Kuntal