copy-pasting data from website table to libreoffice, formatting it as a csv in geddit

Yet another task getting data out of a fairly nasty/incoherent web-based table and moving it into LibreOffice for sorting/project planning. Presumably this is all “easier” with scripting but I don’t have the time/patience/inclination to learn, so here is my hacky method! It worked for 95% of my data, so I had 5 of 100 lines…Continue reading copy-pasting data from website table to libreoffice, formatting it as a csv in geddit

Removing button names etc from a list of blogs/files/emails copied from a website (Gedit, Fedora)

Often if I have copied a list of blogs, files or emails from an app or website, where there is no export function, button names such as “Edit” and “Delete” will copy over. Often in a small list of items there will be several repeated junk phrases for each item of text I actually need.…Continue reading Removing button names etc from a list of blogs/files/emails copied from a website (Gedit, Fedora)

Quickly removing date/time stamps from a text file using find and replace (Gedit, Fedora)

I have been writing a lot recently about little obstacles I have come across while helping the Church of England move content from their old sites to their new ones. Making a list of all the content to be moved is often the first job, but many of the older/proprietary platforms don’t have the ability…Continue reading Quickly removing date/time stamps from a text file using find and replace (Gedit, Fedora)

Removing some text items e.g. files with certain extension, from a list in Libreoffice using COUNTIF

I am currently doing some work for the Church of England, moving and improving the repository of liturgy to their new website. There are a lot of files involved so using shortcuts for sorting out data and lists is vital. Removing unneeded items from a list Today I was working with an export of a…Continue reading Removing some text items e.g. files with certain extension, from a list in Libreoffice using COUNTIF

Removing double line breaks in a text editor on Linux (Fedora)

While copy-pasting an index from a website to a spreadsheet (google sheet) recently, I found several annoying points of formatting: Each item was an html link, which could not be easily removed in bulk The items were “double spaced” using two new lines after each item. I found the easiest way to remove this formatting…Continue reading Removing double line breaks in a text editor on Linux (Fedora)