topic Uploading a file in Application Development and Automation Discussions

Uploading a file

Former Member — Tue, 17 Mar 2009 16:42:47 GMT

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

Re: Uploading a file

former_member376453 — Tue, 17 Mar 2009 16:44:09 GMT

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

Kuntal

Re: Uploading a file

Former Member — Tue, 17 Mar 2009 17:20:28 GMT

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

Re: Uploading a file

Former Member — Tue, 17 Mar 2009 17:32:37 GMT

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

Re: Uploading a file

former_member156446 — Tue, 17 Mar 2009 17:37:47 GMT

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.

Re: Uploading a file

former_member376453 — Tue, 17 Mar 2009 18:01:00 GMT

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