Creating multiple unix files based on internal table data

[Former Member]

Hi,

I have an urgent requirement.

Data is contained in .txt file. I have uploaded data to internal table using gui_upload.

The .txt file has rows with same and different company codes. The requirement is to create files based on company codes. The rows with same company code has to be in the same file.

The files created has to be send to a different folder also.

Please help me in doing this.

Points will be given to all helpful answers.

Thank you,

Nobin

[Former Member]

Get all the company codes in the file in a new internal table which contains only one field, company code and delete the adjacent duplicates after sorting.

Loop over this table, then loop over the data table where the company code = company code.

Append the data in a third temporyry table or transfer that data right away to the file. The directory can contain the company code name, just concatenate it.

Brief description, but it should do the trick.

Bert