Process Kindle My Clippings.txt

[zsviczian]

See the accompanying video here: https://youtu.be/n3dbH2c3l0M

I use this extremely rudimentary script to convert my Kindle Clippings into something slightly more editable.

My process:

1. Download My Clippings.txt from the Kindle (connect Kindle to PC with USB and download the "documents/my clippings.txt" file)
2. I copy the contents of Kindle highlights into an empty document in Obsidian (or rename it to My Clippings.md and drop it into your Obsidian folder)
3. Open My Clippings.md in Obsidian and run the templater script.
4. The result is placed on the clipboard. Create a new document or open the document where you want to place your formatted clippings and paste (CTRL+V)

<%*
const editor = this.app.workspace.activeLeaf?.view?.editor;
if(!editor) return;

const linecount = editor.lineCount();
let titles = [];
for(i=0;i<linecount;i++) {  
  if(i%5==0) {
    const line = editor.getLine(i);
	if(!titles.includes(line)) {
	  titles.push(line);
	}
  }
}

const title = await tp.system.suggester(titles, titles,false,"Select book from list");

let output = [];
let page = 0;
let includeLine = false;
let isNote = false;
for(i=0;i<linecount;i++) {
  const line = editor.getLine(i);
  if(i%5 == 0) {
    includeLine = line == title;
  }
  if (includeLine && i%5 == 1) {
    const p = line.match(/(\d+)/);
	if(p && page!=p[0]) {
	  page = p[0];
	  output.push("#### "+page);
	}
	isNote = line.startsWith("- Your Note");
  }
  if (includeLine && i%5 == 3 && line !="" && line !="\n") {
      output.push((isNote ? "" : "> ") + line);
  }
}

window.navigator.clipboard.writeText("# "+title+"\n\n"+output.join("\n\n")+"\n\n");
new Notice ("Extracted kindle highlights are available on the clipboard.",4000);
%>

[zsviczian]

Here’s an updated version of the script. This will handle multi paragraph notes, not just highlights.

<%*
const editor = this.app.workspace.activeLeaf?.view?.editor;
if(!editor) return;

const linecount = editor.lineCount();
const titles = [];
let titleNext = true
for(i=0;i<linecount;i++) {
  const line = editor.getLine(i);
  if(line.startsWith(`==========`)) {
    titleNext = true;
  } else if(titleNext) {
    titleNext = false;
    if(!titles.includes(line)) {
      titles.push(line);
    }
  }
}

const title = await tp.system.suggester(titles, titles,false,"Select book from list");

const output = [];
let page = 0;
let includeLine = false;
let row = 0;
let data = ``;
titleNext = true;
for(i=0;i<linecount;i++) {
  const line = editor.getLine(i).trim();
  if(line.startsWith(`==========`)) {
    if (includeLine) output.push([page,data]);
    titleNext = true;
    includeLine = false;
  } else if(titleNext) {
    titleNext = false;
    includeLine = (line === title);
    row = 0;
  }
  if (includeLine && row === 1) {
    const p = line.match(/(\d+)/);
	page = p ? parseInt(p[0]) : -1;
	data = line.startsWith("- Your Note")?`> [!note]`:``;
  }
  if (includeLine && row > 1 && line !== "" && line !== "\n") {
  	if (line.match(/^\d+\.\d+\.\d+./)) {
      data = `#### ${line}`;
	} else if (line.match(/^\d+\.\d+./)) {
      data = `### ${line}`;
	} else if (line.match(/^\d+./)) {
      data = `## ${line}`;
	} else {
      data += `\n> ${line}`;
    }
  }
  row++;
}

window.navigator.clipboard.writeText(
  "# "+title+"\n\n" +
  output
    .sort((a,b)=>a[0]>b[0]?1:-1)
    .map(x =>x[1].startsWith(`##`) ? `${x[1]}\n` : `${x[1]} ^${x[0]}\n`)
    .join("\n") +
 "\n"
);
new Notice ("Extracted kindle highlights are available on the clipboard.",4000);
%>

[zsviczian]

Here's my latest updated Templater script: PS - Process Kindle Clippings - v2.md

[thomaspmann]

Hi, there seems to be a bug in the code for the book "Zero to One". The attached clippings file is not processed correctly as shown by the incorrect location (only a ^ is shown) and missing comments (like "Preface ZERO TO ONE")

My.Clippings.txt