Is it possible to just extract the folder where the file is?

[meet-v]

I am trying to create a dashboard with multiple dataview queries for different use cases. Now, I already follow a folder structure that enables me to focus on one category of tasks at a time.

So, when I use the following dataview query, it is already filtered to that category:

table item,date-created,file.folder
from "<category folder>"
where <condition>
limit 30

However, the file.folder reverts with the entire folder path in the vault instead of just the folder name. Is it possible to just get the folder name instead of the whole folder path?

E.g.: For a note at this path: ~OSPath/[Vault Dir]/Root/Category 1/Folder 1/Note 1.md
Actual Result: ~OSPath/[Vault Dir]/Root/Category 1/Folder 1
Expected Result: Folder 1

[holroy]

It's correct that file.folder returns the entire path within the vault, to get to parts of this you can use split(file.folder, "/") to get an array with each subfolder. If you combine that with slice(..., -1) you'll get the last folder. So try:

slice(split(file.folder,  "/" ), -1)

[meet-v]

Thanks! That does it.