Remove blanks

[LasseJ]

Hi all

You've been kind to help me out before, so here we go again:

I have a field called "Surname". For some reason I cant "find" it if the data contains of two surnames (ex. John Paul and searching on "Jo Pau")

I guess it has something to do with the way the data has been imported in the first place, because if I rewrite the data (or remove the blank and hit space once again), the problem disappears.

I have a similar(?) problem with unnessecary blanks trailing the surname. I would also like to get rid of these.

Does anyone know how to solve the problem an easy way?

Best regards

Lasse

[comment]

Removing extraneous spaces should be easy:

TrimAll ( Surname ; 0 ; 0 )

However, spaces should not interfere with your find, so I suspect you may have some other invisible characters in there. Perhaps you should export the data to a text editor and fix it there.