Export Calculated Field

I would look at the Substring function..

if length(TheField) > 9 then TrimmedField = substring(TheField,1,9).
else TrimmedField = TheField.

or, format the output to only 9 chars.

If you want, email the file and I'll look at it (it's finally slowed
down this afternoon).

Lonnie
lonniedrew@...


--- In vantage@y..., Mario Aguirre <maguirre@l...> wrote:
> Hi, group,
>
> I have an export that needs a field trim to show only 9 characters
from the
> left. Is anybody familiar with using RIGHT-TRIM or LEFT-TRIM? Could
I use
> the same thing I use in Access ( left([Field],9) ? Thank you for
any input.
>
> Mario Aguirre
> Lakin General
>
>
>
>
> [Non-text portions of this message have been removed]
Hi, group,

I have an export that needs a field trim to show only 9 characters from the
left. Is anybody familiar with using RIGHT-TRIM or LEFT-TRIM? Could I use
the same thing I use in Access ( left([Field],9) ? Thank you for any input.

Mario Aguirre
Lakin General




[Non-text portions of this message have been removed]