/ › Blog › File system folders from text, via Excel
    Sign in

    On this page

    • File system folders from text, via Excel
      • Excel sheet

    Info

    • Author: Johnny
    • Date: 2024-07-11
    • Link: jdcm.al/blog/0067

    Community

    • Forum
    • Discord

    File system folders from text, via Excel

    On the forum, Kelso asks:

    How do I change my MindNode into a folder structure onto my computer?

    Great question, best answered with a video.

    Excel sheet

    You can download the sheet from the video here.

    Formulas

    Fill the column

    =IF(C5<>"", C5, D4)

    Create a file path, 'escaping' spaces with a backslash

    =IF(G7="", "", SUBSTITUTE(CONCAT(D7, "/", F7, "/", G7), " ", "\ "))

    Create the mkdir -p command

    =IF(H7="", "", CONCAT("mkdir -p ", H7))

    Create the echo command to create text files

    =IF(G7="", "", CONCAT("echo # ", G7, " > ", SUBSTITUTE(G7, " ", "\ "), ".txt"))


    ā—€ Back The classes of to-do, p… Standard 'life admin' p… Next ā–¶ (Use the ← arrow keys →)

    Written by humans • Search • Support