Scripts by kenNash

// Name: Create Subfolder
// Description: Creates a subfolder of the selected folder.
// Author: kenNash

import "@johnlindquist/kit"

const parentFolder = await selectFolder("Select the parent folder")

const subfolderName = (await arg({
  placeholder: "Enter new subfolder name",
  strict: false,
  validate: input => input.trim().length > 0 || "Folder name cannot be empty",
})).trim()

const newSubfolderPath = path.join(parentFolder, subfolderName)

await ensureDir(newSubfolderPath)

await notify(`Created: ${newSubfolderPath}`)
await revealInFinder(newSubfolderPath)// Name: Create Subfolder in Selected Folder

// Name: Create Subfolder
// Description: Creates a subfolder of the selected folder.
// Author: kenNash

import "@johnlindquist/kit"

const parentFolder = await selectFolder("Select the parent folder")

const subfolderName = (await arg({
  placeholder: "Enter new subfolder name",
  strict: false,
  validate: input => input.trim().length > 0 || "Folder name cannot be empty",
})).trim()

const newSubfolderPath = path.join(parentFolder, subfolderName)

await ensureDir(newSubfolderPath)

await notify(`Created: ${newSubfolderPath}`)
await revealInFinder(newSubfolderPath)

// Name: Create Subfolder
// Description: Select a folder, then create a new subfolder inside it.
// Author: kenNash
// GitHub: kenNash

import "@johnlindquist/kit"

const parentFolder = await selectFolder("Select a parent folder")
if (!parentFolder) exit()

const folderName = await arg({
  placeholder: "Enter new folder name",
  strict: false,
  validate: async (input: string) => {
    const name = input.trim()
    if (!name) return "Folder name cannot be empty"
    if (/[\\/:*?"<>|]/.test(name)) return "Folder name contains invalid characters"
    const fullPath = path.join(parentFolder, name)
    if (await pathExists(fullPath)) return "A folder with this name already exists"
    return true

// Name: Download Instagram Video
// Description: Prompts for an Instagram video URL and downloads the video file locally.
// Author: kenNash
// GitHub: kenNash

import "@johnlindquist/kit"

let instagramGetUrl: any
try {
  instagramGetUrl = (await import("instagram-url-direct")).default
} catch {
  await installMissingPackage("instagram-url-direct")
  instagramGetUrl = (await import("instagram-url-direct")).default
}

const urlInput: string = await arg({
  placeholder: "Paste Instagram video URL",
  strict: false,
  validate: (input: string) => {
    try {

// Name: Excel Rows to Markdown
// Description: Converts an Excel file into one Markdown file per row named by the ID column.
// Author: kenNash
// GitHub: kenNash

import "@johnlindquist/kit"
import * as XLSX from "xlsx"

const excelPath = await selectFile("Select the Excel file (.xlsx or .xls)")
const outDir = await path({
  placeholder: "Select output directory",
  onlyDirs: true,
})

const buffer = await readFile(excelPath)
const workbook = XLSX.read(buffer, { type: "buffer" })
const sheetName = workbook.SheetNames[0]
if (!sheetName) {
  await div(md(`# No sheets found in the workbook.`))
  exit()

// Name: Excel Rows to Markdown Files
// Description: Convert an Excel file to one Markdown file per row named by ID with specified fields.
// Author: kenNash
// GitHub: kenNash

import "@johnlindquist/kit"
import * as XLSX from "xlsx"

const excelPath = await selectFile("Select the Excel file (.xlsx or .xls)")
if (!excelPath) {
  notify("No file selected")
  exit()
}

const outputDir = await path({
  placeholder: "Select an output folder for the Markdown files",
  onlyDirs: true,
})

await ensureDir(outputDir)

// Name: Wrap in Curly Braces
// Description: Wraps selected text in curly braces or inserts empty braces with cursor positioned between them
// Author: kenNash
// GitHub: kenNash

import "@johnlindquist/kit"

const selectedText = await getSelectedText()

if (selectedText && selectedText.trim()) {
  // Wrap the selected text in curly braces
  await setSelectedText(`{${selectedText}}`)
} else {
  // Insert empty curly braces and position cursor between them
  await setSelectedText("{}")
  // Move cursor back one position to place it between the braces
  await keyboard.pressKey(Key.ArrowLeft)
}

// Name: Yesterday's Date
// Description: Prints yesterday's date in yyyy-MM-dd format.
// Author: kenNash

import '@johnlindquist/kit'

// Get today's date
let yesterday = new Date()

// Subtract one day to get yesterday's date
yesterday.setDate(yesterday.getDate() - 1)

// Format the date to yyyy-MM-ddlet formattedDate = formatDate(yesterday, 'yyyy-MM-dd')

// Open the formatted date in the editor
await editor(formattedDate)