Azure Data Factory - Search a folder existance (based on string in a folder name) under nested folder structure in file system

Rohit Agarwal 1 Reputation point
2022-01-06T18:42:15.103+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,646 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.