Azure Data Factory - Search a folder existance (based on string in a folder name) under nested folder structure in file system
Hi Everyone,
I have a file system path like below:
\FileServer\Folder1\Folder2\<subfolder>\<subfolder>\YYYY\<Target Folder>
Up to the 'Folder2' path is fixed. Under that there could be multiple nested sub-folders and I do not know nested sub-folder names.
<Target Folder> Name contains multiple string. Example 'foo,bar,text'
I need to search for existence of a folder which contains string 'text' under nested path '\FileServer\Folder1\Folder2\<subfolder>\<subfolder>\YYYY\'.
If any target folder which contains string 'text' exists then I should get the full path up to that target folder
Thanks for your help.
Rohit