topic Re: Data upload. in Application Development and Automation Discussions

Data upload.

Former Member — Fri, 06 Jun 2008 05:57:40 GMT

hi,

I have one tab delimited tab file in presentation server.

frist i was declared one internal table like this.

BEGIN OF IT_tab OCCURS 0,

REC(256),

END OF IT_tab.

now i upload this flat file data using ws_upload F.M.

now i want split this data and send to new internal table according to fields.(total 14 fields).

can any one please give the solution.

thanks in advance

Re: Data upload.

Former Member — Fri, 06 Jun 2008 06:47:15 GMT

1/ loop at table.

2/ split the fields value and move to corresponding/appropriate fields of work area.

3/ Append it ti int, table.

Note, you should know where to split/cut the values in int. table.Length of each field is the key factor for this.Also, take care of missing leading zeros and spaces.

- Sonal

Re: Data upload.

Former Member — Fri, 06 Jun 2008 08:23:16 GMT

Hi,

you are having a tab delimited file means each fields are seperated with tab.

the internal table in which you want to pass the file's data ,just pass that internal table to the function module ws_upload . The data will auto matically go into the corresponding fields.

Instead taking data into an internal table which is of character type.

Just declare the internal table structure with field sequence same as there in your file.

If you follow this method you will reduce ur coding efforts.

Re: Data upload.

Former Member — Fri, 06 Jun 2008 08:42:17 GMT

Hi,

You can upload the tab delimited data using GUI_UPLOAD. where you have to pass 'X' has _any delimiter.

Otherwise you read each record into a string and then use the following syntax.

SPLIT REC at ',' into wa_field1 wa_field2 wa_field3 .........

Hope this is clear for you,

Thanks and regards