Hello everyone,
I am new in this forum, and I hope you can help me solve this. What I have to do:

- unzip multiples files (around 40 zipped files), into "separated" 40 folders (names of the folders remain as names of zipped files)
- inside the folders after unzip are several csv files. Then I need to create new column (for remark) then append and merge them all into a big single data file.

However, I guess I dont know how to specify the folder path, so that when I do the unzipfile, it does not automatically create separate folders (with folders name = name of zip files)
This is my current code when I try to unzip multiple files into separated folders, which did not work:

HTML Code:
local sourcedir "\filezip"
local unzipdir "filezip\temp"
cap noi mkdir "`unzipdir'"
local fls: dir "`sourcedir'" files "*.zip"
cd "`unzipdir'"
foreach f in `fls' {
    di "Working on `f'"
    unzipfile "`sourcedir'/`f'", replace
}
Hope that someone can help me with this. I guess when I know how to specify the folder path (maybe this is the issue), I can continue with the append/merge files
Many thanks