Extracting CSV file names out of ZIP files

[tejagst]

Hello,

I have a bunch of ZIP files each of which  contains 2 CSV files; "SNV_4G_CU_Report_YYYYMMDD.csv" and "SNV_4G_SleepingCell_Report_YYYYMMDD.csv". I would like to extract the filenames of the CSV file from each ZIP file. In this case the output I would expect is something like the "FilePath/Zip file name|||CSV file name".

This is to help in running a batch macro which has been configured to run on CSV files (specifically the first CSV file in the ZIP file).

[AlteryxUserFL · Accepted solution]

This article should cover your use case well : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reading-Multiple-Files-Of-Your-Choice-...  

[tejagst]

Yes, this solution worked for my purpose (CSV files). I was wondering if there is functionality to read all the file names from the ZIP file irrespective of the extension.

[bobpeers]

Try this tool I made, extract all files from Zip files and returns the contents into the workflow.

Post is here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Extracting-files-from-zip-files-or-tar...

and Workflow is on the Gallery: https://gallery.alteryx.com/#!app/Zip/5f4017838a933718f4bef65d