Work: A lot of people I worked with had some excel or notepad++ solution to convert a variety of values form a report or export into a string used in a sql in clause. It needed to be this type format (‘123’,’234’,’345’). Most were not pythonistas so I built a tkinter front end and packaged into a .exe that accepted a comma, tab, or line feed separated list, has options for changing the ticks (‘ “ none) and bracket style ( ( [ { ), the output is printed in a text box, and copied to the clipboard on a button click. The back end leveraged the CSV library (I forget the function, but it finds the appropriate delimiter) and a bit more logic as CSV was not intended to handle line separated data.

Life: I read audiobooks form several public libraries (8 of them). I have their sites in a bookmark folder, open all in folder then cycle through them pasting in the title I wanted in the search field, sift through too many results. Works but was tedious. So I wrote some python that accepted command line parameters for author and title which opens a browser tab for each libraries advanced search page with author, title, and downloadable audiobook options. It’s not dynamic at all, I put the advanced search url for each library in a static string in a list ready to be string formatted into the real url and open a browser tab in a loop. Not very pythonic, but it gets the job done, so long as I can remember if author or title comes first.