Unpacking XLS, CSV, pipe delimited, XML into flat file

[Cibella]

I need to unpack the above files (as a start) into a text file for uploading onto the iSeries. Planning to control that (as a sub-process) inside RPG directly from the IFS before an RPG module rips it into an existing DB2 file.

Alternatively, I'll create the PHP to execute in another process so that the RPG pgm can just get on with it.

However, the missing link is: Is there existing PHP code which will miraculously convert the various files into a flat text file?

[GLS400]

Re: Unpacking XLS, CSV, pipe delimited, XML into flat file

Hi Cibella:

What you are trying to do sounds too much like work.

All of those formats can be converted to .csv using excel. Save the .csv on the IFS and use CPYFRMIMPF to convert to a physical file.

Or am I just not understanding your objective?

Best of Luck
GLS