I have a problem understanding variables and how to separate a string, but first, a little bit of context. I read books on my Kindle. Then I centralize all the highlights (Kindle, command, podcasts, etc.) in Readwise. From Readwise, I import the highlights to Obisidian using the “Readwise Official” plugin.
When importing from Kindle (sync), the “author” for the book reads: “Pauline Maclaran, Michael Saren, Barbara Stern, and Mark Tadajewski.” In that way, when I sync readwise and obsidian, I get the author as [[Pauline Maclaran, Michael Saren, Barbara Stern, and Mark Tadajewski]].
I am trying to split the comma-separated values and ditch the “and” connector, so the authors are exported to obsidian as [[Pauline Maclaran]] [[Michael Saren]] [[Barbara Stern]] [[Mark Tadajewski]]. I have played with a custom format, but I can’t separate the string. Does anyone know how to implement that in the readwise plugin?
Similarly, I have been trying to construct a list of books in my vault using data view. I am currently using the following query:
dataview TABLE author, source, dateformat(file.cday, "MMM yy") AS "imported" FROM "" WHERE category = "books" SORT file.name, ASC
The query somehow lists the authors separated, but I if understand that bullet point correctly (see picture) is still one long sting. How can I separate the string in “dataview” and show, for example, only the first author? I have tried with “split” to separate the authors without success.