Phil_Rosier
9 years agoLevel 4
DQL - Bulk input of search paths
Hi,
I have a report which searches a list of paths for certain types of files such as vmdk, for example.
FROM dfspath
GET absname
IF extension = 'vmdk'
AND (substri(dfspath.absname, '<search path1>')=1
OR substri(dfspath.absname, '<search path2>')=1)
Is there a way to read in the list of search paths from a CSV file rather than hard-coding them into the report. I tried using the IN FILE expression but this looks for a exact match of the pathnames whereas we are search for files below these paths.
Alternatively, does DQL support wild characters such as '*' or '%'
Any advice is much appreciated as always.
Phil