removing letters from the right

[hartmut]

I have a field which has 23 numbers and I would like to remove the first 10 from the field.

for example

the number is

"27457839462738493823432"

I would like to have the following remain in my field

"2745783946273"

I understand how to find it with right function but not how to remove the 10 digits from the right.

Thank you

[Lee Smith]

If you are just wanting like the first 13 characters in your field, use the Left (YourField; 13)

Edited July 19, 2007 by Guest

[aholtzapfel]

in a script it would be

SetField (yourfield; Left(yourfield;length(yourfield)-10))

or you could do a replace with calculated result

Left(yourfield;length(yourfield)-10)