Auto-removal of trailing spaces; I LOVE it

Been spending a lot of time cleaning up taxon tree and authors. Some of our past errors have been from users who accidentally add spaces before/after the data entry.

I LOVE to see those trailing spaces auto-removed. I’m not 100% clear if leading spaces act the same way, but either way, GREAT!


You can get rid of the leading and trailing whitespace with the following SQL statement:

update taxon 
set Name = trim(Name),
	FullName = trim (FullName),
	Author = trim(Author);