What steps will reproduce the problem? 1. Have a cell with “ x”as its value (the space being a non-breaking space). 2. Apply the common transform “Trim leading and trailing whitespace” to its column.

What is the expected output? What do you see instead? The cell’s value should become “x”. Instead, it does not change.

What version of Google Refine are you using? 2.5

What operating system and browser are you using? Mac OS X 10.7.4 Chrome Version 21.0.1180.75

Is this problem specific to the type of browser you're using or it happens in all the browsers you tried? The same behavior appears in Safari 6.0 (7536.25).

Please provide any additional information below. Perhaps this is the intended behavior. But it does not reflect the function’s name (“Trim leading and trailing whitespace”).

This function implements an "old-school" definition of whitespace as described here: http://docs.oracle.com/javase/1.4.2/docs/api/java/lang/String.html#trim()

There are lots of Unicode whitespace characters (em-space, en-space, thin space, nbsp, etc) which aren't included.

Updated to use the Guava method CharMatcher.WHITESPACE.trimFrom(s) in r2528. Still needs tests.

I've added some basic tests. The two characters that the Guava method doesn't appear to handle are 0-width NBSP "\uFEFF" and Word Join "\u2060". I'm not going rely on Guava for now rather than trying to work around this.