Check last folder name using filter tool

[Sshasnk]

I get multiple file paths from different directory tools now I have to segregate based on the folder name

FilePath

C:\program\ABC\lmnop.xlsx

C:\program\mnop.xlsx

C:\program\ABC.xlsx

Check if the last folder is ABC or not (using a filter tool),if yes it should come in true anchor or else it should be in false

[DataNath]

@Sshasnk I provided a solution to this yesterday. Let me know if there’s a reason this doesn’t work and can revisit if needed: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Check-if-the-folder-name-is-present-or...

[binuacs]

@Sshasnk you can use the regex replace function to check whether the folder name is ABC or not in the filter tool