This has got to be easier than I'm making it...
I often receive files (can be.xlsx or .csv) containing in excess of 100k records in them, these take some time to upload and I'd like to zip them up to speed up this part of the process up and then process the contents when they arrive.
On arrival I am able to decompress the files into a folder and I want to process them depending on the file extension, but I can't figure this last bit out. Is there a way of determining the file name and extension of the decompressed file that comes out of the zip file?
Many thanks
Barry