Extracting CSV file names out of ZIP files

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).

Input

Accepted answers

AlteryxUserFL

This article should cover your use case well : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reading-Multiple-Files-Of-Your-Choice-from-ZIP-files-with-ZIP/td-p/444413

All comments

AlteryxUserFL

This article should cover your use case well : https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reading-Multiple-Files-Of-Your-Choice-from-ZIP-files-with-ZIP/td-p/444413

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703