Delete spaces imported from XL

[Maxwell Morlay]

I have imported a file from XL that has many spaces at the end of each piece of data. Can I run a script to get rid of those spaces?

Your help is much appreciated. Maxwell Morlay

[spb]

One such script would be to use a Replace with Calculation for each field:

Show All Records

Go To Layout (where all fields are visible)

Replace Contents [No Dialog, "FieldA", "Trim[FieldA]"]

Replace Contents [No Dialog, "FieldB", "Trim[FieldB]"]

... etc.

You are replacing the contents of the field with a Trimmed version of the same contents, effectively removing both leading and trailing spaces.

Steve Brown