Not that I am aware of. Why not script it?
Go to Layout [(Layout #1)]
Import [Restore, No Dialog]
Replace [No Dialog, Field1, Trim (Field1)]
Replace [No Dialog, Field2, Trim (Field2)]
Replace [No Dialog, Field3, Trim (Field3)]
The layout must be layout which has all the fields that Trim is to be used on.
The import command will automatically put only newly imported records in
the current set so that Replace command will only work on them.
If there are lots of fields that need to be trimmed and large numbers of
records to be imported, you might be better off looping through the set
once using several Set Fields steps to trim each field rather than
performing Replace x number of times:
Go to Records [First]
Set Field [Field1, Trim (Field1)]
Set Field [Field2, Trim (Field2)]
Set Field [Field3, Trim (Field3)]
Go to Record [Exit after last, Next]
If you have to do this often, it might be worthwhile trying both and
seeing which is faster. If you find out, I'd be interested to know.
> Does anyone know how I can use the Trim Function to trim fields on import? I
> realize I can use Replace with a calculation once the records are in my
> database but it would be real nice to be able to do this on fields as they are
> imported in! Thanks!
> Tom Klingman