upinflamezzz
IS-IT--Management
I'm trying to simplify my UPS Worldship process. I have an xls file automatically exporting out of my mainframe intoa specified folder. Unfortunately Worldship needs it to be formatting and save as a CSV. I need to write a batch file that will call the excel file, delete the second row, format the zip code column as (Number - Special - Zip) then save the file as a CSV in the same folder. This would happen daily. File kicks out, user clicks on that batch file to modify the file, the the user starts using Worldship by referencing the order number (Column Number). Thanks for any help.