Find single file in .zip folder?

Six Stars

Find single file in .zip folder?

I have a job where I need to find a file. Depending on date, the file will either be in a specific folder or the file will be one of many files in a zipped folder stored in a different location. The name of the zipped folder changes depending on date and there will be multiple zipped folders with similar names in that location. As an example, sometimes the file will be in C:\user\files\ and sometimes it will be in C:\user\archive\files_20180501.zip

 

What is the best way to set up the job to find the file?

 

Thanks,

Cara 


Accepted Solutions
Highlighted
Seven Stars

Re: Find single file in .zip folder?

 Using the tFileList component you have option there include subdirectories and in Filemask you can use the pattern which file you want to search. File Mask can be like "your file name*+context.date+".zip" and directory as your directory where to search.

View solution in original post


All Replies
Highlighted
Seven Stars

Re: Find single file in .zip folder?

 Using the tFileList component you have option there include subdirectories and in Filemask you can use the pattern which file you want to search. File Mask can be like "your file name*+context.date+".zip" and directory as your directory where to search.

View solution in original post

Six Stars

Re: Find single file in .zip folder?

Thanks, I'll try that!

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog