recipes and stuff for openrefine, grel expressions

openrefine_scratchpad.txt

################
Transform cells containing a single name in `Fn Mn Ln` format into `Ln, Fn Mn` 

value.split(/ (?=[^ ]*$)/).reverse().join(", ")

the split regex catches the last " " space that occurs and takes the characters after it as the last name,
then moves it to the front and joins the values with comma-space.
To perform this transformation, at the top of a column, go to Edit Cells> Transform and paste the expression into the box.
####################

####################
JYTHON
Transform cells from pipe-delimited to python-list-like
Jane Doe|John Doe --> ["Jane Doe","John Doe"]
value = value.encode('latin-1') 
x = '["{}"]'.format(value.replace("|",'","')) 
return x
####################