Hello
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.
I can’t solve the following problem
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?
Another problem
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.
Thanks!