Maybe you can adapt something from there ...
You can simply solve your problem using this filter expression ...
"%_folderpath%" HAS "\Bandhouse"
... or use a regular expression to split the folderpath into folder components ...
"$regexp(%_folderpath%,'^.+?\\\\(.+?)\\\\(.+?)\\\\(.+?)\\\\.+$','$3')" IS "Bandhouse"
Here the components are ^Drive\Folder1\Folder2\Folder3\Remainder$
Note: The filter does not 'pull' something from anything, but restricts the list view for the currently loaded files, fitting to the filter expression.
If you want to 'pull' a partly value from the given file's folderpath, then you have to apply a scripting expression within a converter or action dialog.