How to display only last subtag in Dataview

Help
1

In Dataview table, I only want to display the last subtag (for example ‘Graphic’). However, when using file.etags, the full tag (e.g. ‘Software/Graphic’) is shown instead. How can I extract and display only the last subtag?

My code:
image
What’s displayed:
image

2

The following displays just Graphic. What you want?

---
tags: Software/Graphic
---

```dataview
TABLE 
string(map(file.etags, (t) => split(t, "/")[length(split(t, "/")) - 1])) AS Tags
FROM #Software/Graphic
```

tag
tag1750×618 106 KB

Reference: Dataview : display a subtag only? (Also discussed : Sort/Group by subtag) - #4 by mnvwvnm

1 Like
3

There has been some addition to dataview making this a little nicer: map(file.etags, (t) => slice(split(t, "/"), -1) This would pick the last part of any nested tag within file.etags.

1 Like
4

Thank you for your amazing solution! I do have a small issue, though. When a tag is not nested and consists of only one word, Dataview displays it with a # at the beginning. Is there a way to remove the # while keeping the code clean? Thanks again!
image
image

1 Like
6

So you don’t want the hash tag… Then you could do replace(t, "#", "") or substring(t, 1) instead of the t inside of split. Or you could do a regexreplace on the entire string, maybe something like regexreplace(t, "#.*\/?(.*)", "$1") instead of the slice and split combo.

All of these are untested, and written in the dark of the night, so if they’re not working I’ll do better tomorrow.

2 Likes
7

Hi.

The code suggested by @holroy works in a local test file:

---
tags: 
  - Software/Graphic
---

#Obsidian #Books


```dataview
TABLE 
string(map(file.etags, (t) => split(replace(t, "#", ""), "/")[length(split(t, "/")) - 1])) AS Tags
WHERE file.name = this.file.name
```

hide hashtag
hide hashtag1710×808 90.9 KB

1 Like
8

Here is a complete working example with all three variants on removing the # and splitting the remaining and only listing the last part of a nested tag.

```dataview
TABLE
  join(map(file.etags, (t) => regexreplace(t, "#(?:.*\/)?(.*)", "$1"))) as regexreplace,
  join(map(file.etags, (t) => slice(split(replace(t, "#", ""), "/"), -1))) as sliceSplitReplace,
  join(map(file.etags, (t) => slice(split(substring(t, 1), "/"), -1))) as sliceSplitSubstring
WHERE file = this.file
```

Based on the example file provided by @Guapa , this gives:

image
image1033×137 15.4 KB

Which one to use? I’d say, use the one which makes the most sense to you, and you possibly could recreate on your own in a similar case later on.

2 Likes
9

Thank you so much for the amazing answers. I didn’t expect to receive such a great support. One more question, what is the difference between ‘join’ and ‘string’. In this context I can use both and the result is the same

1 Like
10

With string() you do an implicit join(), and you’re hoping for a good result. Using join() you can control what is used for joining the elements. So if you wanted to get Obsidian | Books | Graphic, you could get that using join( ..., " | ").

1 Like