Re: Trim spaces on record import?
- From: Matt Wills <Im@xxxxxxxx>
- Date: Wed, 30 Aug 2006 21:37:22 GMT
See the Trim function in Help.
Most basically, set YourField to autoenter Trim ( YourField ). Make sure
"Do not replace existing value" is UNCHECKED.
Trim removes only leading and trailing spaces. There are Custom
Functions posted at http://www.briandunning.com that do more. Trim 4,
for instance, "removes *all* leading and trailing white space from the
supplied text, including tabs, carriage returns, spaces and non-breaking
spaces."
Matt
In article <no.email-0D5F7D.15440130082006@xxxxxxxxxxxxxxxxxxxxxx>,
David Stone <no.email@xxxxxxxxxxxxxx> wrote:
Is there a way to get FM Pro 8.5 to trim trailing spaces.
from entries in records imported from Excel files during
the import, or will I have to run a script to replace the
field contents in place once the import has completed?
(No, I can't get the powers that be to provide me Excel
files without the extra padding in the first place - wish
I could!)
- Follow-Ups:
- Re: Trim spaces on record import?
- From: David Stone
- Re: Trim spaces on record import?
- References:
- Trim spaces on record import?
- From: David Stone
- Trim spaces on record import?
- Prev by Date: Re: Unbelievably slow searching
- Next by Date: simple header question
- Previous by thread: Trim spaces on record import?
- Next by thread: Re: Trim spaces on record import?
- Index(es):
Relevant Pages
|
