Process CSV-Files dynamically

Former Member — Thu, 13 Dec 2007 08:46:13 GMT

Hi all,

I need to process CSV-Files dynamically, i.e. not using a static order for splitting the values of the lines into the according variables, but determining the mapping dynamically using a header line in the CSV-File.

For instance:

#dcu;item;subitem

827160;5111001000;3150

So if the order in the the CSV-File changes to e.g.

#item;dcu;subitem

5111001000;827160;3150

the program should fill the corresponding variables (ls_upload-dcu, ls_upload-item, ls_load-subitem) dynamically without the need to change the code.

If anyone has a solution, please let me know.

Thanks,

Thomas

Re: Process CSV-Files dynamically

Former Member — Thu, 13 Dec 2007 08:52:26 GMT

Try to use variants concepts

topic Process CSV-Files dynamically in Application Development and Automation Discussions

Process CSV-Files dynamically

Re: Process CSV-Files dynamically