I am trying to find a set of files with extension .zip from a file folder. I am working around a DOS Script for this which is doing a lot of other functionality..
For some wierd reason when i code in my DOS Script the following Syntax
dir /a-d|find ".zip" It is giving me an error saying
Result = find: unable to access ".zip": The system cannot find the file specified.
The same syntax works fine from the Command Prompt...
![Evil or Very Mad :evil:](./images/smilies/icon_evil.gif)
Never the less the command dir /b works which is giving me all the files in the directory in short form...
Is there Some String function in Datastage which will Slit through the whole directory brought by dir /b and give me only the names which fit an Pattern like '.zip'...
I am not able to use Field or any other commands as there are no delimeters
Any help will be really appreciated
Thanks
Pavan