In this example, I will condense a list of paired-down postcodes into a short list by removing all the duplicate entries.
Category: Nerdy-Gudry
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 every other line, or every nth line, from a list using LibreOffice Calc
This is particularly useful when working with lists copied and pasted from withing software (like WordPress or Drupal). Perhaps you are making a list of blogs you have written or you want to check the order of a menu: often when you copy this data you get spare bits of html such as button names…Continue reading Removing every other line, or every nth line, from a list using LibreOffice Calc
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
Change a list with colons to list with new lines in linux (fedora)
The other day I needed to remove double line breaks from a list to quickly put it in a spread sheet. Similarly, today I needed to change a list like: Heading Item; Item; Item; Into Heading Item Item Item In order to put it into a spreadsheet. Here is what I did: I pasted the…Continue reading Change a list with colons to list with new lines in linux (fedora)
Allow your contributors to upload a profile picture to WordPress without using Gravatar
There are lots of benefits to contributors uploading a profile picture (also known as an Avatar) to your WordPress site: it makes it clearer who is writing each blog, it helps the writer feel part of your site, it makes your site more personable and friendly which helps your readers to engage more. WordPress, by…Continue reading Allow your contributors to upload a profile picture to WordPress without using Gravatar
Android share suggesting inappropriate contacts
This issue appears to be closed/resolved on the android bug tracker but may still exist on your phone if you have not updated or if no update is available. The Android share menu has been a great feature for me, for example, when I am viewing a cute pick of my cat, I can click…Continue reading Android share suggesting inappropriate contacts
How to open gparted in fedora 25 (wayland): Gtk-WARNING **: cannot open display: :0
Today’s task list involved installing Fedora 25 (yay!) on my new computer and reformatting some hard drives to use as backup disks. The install was fine however I couldn’t seem to get gparted started (poet / know it). Gparted is the tool I find most useful for dealing with hard drives, partitions etc, but apparently…Continue reading How to open gparted in fedora 25 (wayland): Gtk-WARNING **: cannot open display: :0
How to randomly select data from a column in libreoffice
This is a up-to-date variation of some docs I found useful, the original was made by johnSUN. My problem Today I was researching for a possible change in the phpList UI: right now the behaviour of the menu item “Send a campaign” depends on if you have draft campaigns or not. If you have no…Continue reading How to randomly select data from a column in libreoffice
A discussion of website models for Open Source projects with OpenSAAS element
This blog contains a discussion of website models for Open Source projects with Software as a Service (SAAS) element, and uses four real projects as examples.