Using Lisp to Help With Tasks Such as...Creating Spreadsheet Formulas?
Writing big Excel/Libreoffice formulas can be a pain.
They’re all meant to be one line and unfortunately you’re sometimes forced to duplicate big, repetitive code snippets (A programming no-no).
As an oppurtunity to further my Lisp skills, I decided to create a little script that could help generate one of these big formulas in a more managable way (Manageable in the sense that you can come back to the code and easily tweak it).
This is my first crack at this problem (a minimal viable version) and I plan to come back to it, tweak it, and make it more intuitive. Since I’m new to Lisp, I know there are a lot of things that could be improved.
The following Lisp code will generate an Excel/Libreoffice compatable formula that will extract the domain name from a URL.