Extract the first carachter title and use it for a query

My file have as first character the day of week, so i want to extract it and insert it in this query :

TASK FROM "Produttività 🎯/To-Do List 📝"
where containsword(text, "CHARACHTER EXTRACTED") = true

Give us an example because this is too vague.
Any special character or space separating the day of the week and rest of the file name?

As a shot in the dark, you can try:

FROM "Produttività 🎯/To-Do List 📝"
WHERE containsword(text, this.file.name[0]) 
1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.