Transform String processor in a Prepare recipe not removing leading whitespace
Getting some unusual behaviour from a "Transform String" shaker. When applied to a string column, it does not successfully remove leading/trailing whitespace. When encoding the text to UTF-8 (via the shaker), I can see that there is a non-breaking whitespace encoded there.
Is this behaviour intended? What can we do to go around this?