Check if the folder name is present or not

Question

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

FilePathC:\program\ABC\lmnop.xlsxC:\program\mnop.xlsxC:\program\ABC.xlsx

1. Take the file name and keep it in a separate column (name: filename)

2. Check if the last folder is ABC or not (using filter)

binu_acs · Answer

@Sshasnk One way of doing this

LastFolder_0928.yxmd

DataNath · Answer

@Sshasnk I'd first split out the two parts with the following expressions:

Then for tackling the Directory filter, just check if it ends with \ABC\ like so:

Isolate filename and filter directory.yxmd

Christina_H · Answer

Check out the File functions: File Functions | Alteryx Help

In your case you can use FileGetFileName to get the file name.  For the folder you could use FileGetDir but that returns the whole file path excluding only the filename and extension, so you would need to do more if you just need the final folder.  I used this RegEx formula instead:

REGEX_Replace([FilePath], '.*\(.+)$$^$$+', '$1')