Delete spaces at the end of field contents

Make sure you have all records in the found set (Records > Show All
Records). Click into the field. Go to the records menu > Replace
Records. Click 'by calculation' and specify that it should be:
Trim(YourFieldName). The Trim() function will remove all spaces at the
beginning and end of the field in each record.

Snake Driver wrote:
> Can anyone please tell me how to delete extra spaces and the end of text
> in fields. I have 16,650 records in my database from and old excel
> import. I want to discover a fast and efficient way to delete the spaces
> at the end of multiple values in my database fields.

Snake Driver wrote:

> Can anyone please tell me how to delete extra spaces and the end of
> text in fields. I have 16,650 records in my database from and old excel
> import. I want to discover a fast and efficient way to delete the
> spaces at the end of multiple values in my database fields.

enter browse mode
find all records
go to first record
loop
set field (yourField; trim(yourField)
go to next record, exit after last
end loop

I don't know how long that will take. And you may want to backup your
data first. Good luck.
--
http://clk.ch