Using ZIP file with date/time at beginning of file name

Hi all

I have a ZIP file, containing 1 files that i need to use in a Designer workflow, but the problem I have is the zip file name (e.g. 20210823_Export_Devices_with_User_Details_AU.zip) contains the run date at the beginning of the file name (see attached file).

I am looking for a way for Designer to import the data from the enclosed file, with having to "unzip" the zipped file.

Is this even possible ?

20210823_Export_Devices_with_User_Details_AU.zip

Workflow

Accepted answers

messi007

@StephenT,

Below how you can do it

1 - I used the directory tool in order to let you read all zip files in the folder

2 - The formula is to add the file name to the path to be able to read each file

3- The dynamic Read is to read the file inside the zip

Attached the workflow you have to update the paths on the dynamic and input directory tools

Hope this helps,

Regards

ReadZip_20210824.yxmd

All comments

BA02

Yes, very much possible. If it is a single file, simply drag and drop on the canvas and it will give you the option to select which file (in your case there's only one file) to extract.

messi007

@StephenT,

Below how you can do it

1 - I used the directory tool in order to let you read all zip files in the folder

2 - The formula is to add the file name to the path to be able to read each file

3- The dynamic Read is to read the file inside the zip

Attached the workflow you have to update the paths on the dynamic and input directory tools

Hope this helps,

Regards

ReadZip_20210824.yxmd

StephenT

Thanks @BA02
I was trying to avoid any manual adding of the zip file to the workflow. I have 4 team members working with me on a very complicated workflow, requiring the download and input of 7 files - if they miss one it'll give incorrect data.

@messi007 - your solution worked first time (after a bit of tweaking to use my network drives) - exactly what I was looking for, but didn't know hot to do it. I will mark your solution as accepted.

Thanks again to you both for your valuable input

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703