Newby question: Change full name to initials only

[Adele van der Merwe]

My datasheet contains the full name(s) [column]. How do I change this to initials only? 

[Adele van der Merwe]

Solved it by using the split column option (1,20) and creating two columns. Is there a better way?

[Owen Stephens]

I'd suggest using the 'split' function to split the names into individual words, you can then use 'forEach' to iterate over the list of words and extract the first initial. So e.g.:

forEach(value.split(" "),v,v[0]).join("")

Owen

[Adele van der Merwe]

Thanks! Can't wait to try that when I get the updated list containing all the names. My original spreadsheet only provided the first name. 

--
You received this message because you are subscribed to a topic in the Google Groups "OpenRefine" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/openrefine/8_8S9wPXz_U/unsubscribe.
To unsubscribe from this group and all its topics, send an email to openrefine+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.