Leading and trailing blanks

I have just migrated to endnote 2 from endnote 6.  The library in endnote6 came from a self created file started in the early 1980s.  My problem is that the year field has leading and trailing blanks that cause the date to either not appear or appear as 19…   Is there anyway to remove leading and trailing blanks from the year field for an entire file (approximately 4000 records).  The number of blank spaces are variable between the records.

Thankls in advance for any help