Tag Archives: concatenate

Concatenate in SQLite

I wrote before on using concatenate in OpenOffice / LibreOffice and how this alternatively can be done in R using the paste function. You can do the same in SQLite using a query too.

Posted in Data handling, SQLite | Tagged , , , , | Leave a comment

A concatenate function on steroids for OpenOffice calc

In OpenOffice / LibreOffice Calc, you would normally use CONCATENATE to combine strings from different cells, like in the example below:

Posted in Data handling, LibreOffice / OpenOffice | Tagged , , | 8 Comments

Finding the code for a ‘hidden’ function in R

If you want to understand what a certain function is doing, or you want to adapt it, you can type in the function without bracket on the command line. However, sometimes functions are ‘hidden’.

Posted in Data handling, R computing environment | Tagged , , , | Leave a comment