Removing Characters Past X

[OneStop]

I have a field with various types of data in it. I only need to keep the first 21 characters and remove everything thing else in the field to the right of the first 21.

I've looked at Trim and some various other functions but I just can't seem to figure out how to make it work.

[siroos12]

Use Left() Function:

 

Left( MyTable::MyField ; 21 )

 

you can use it as a calculation of a new calculation field, pointed to your target field or you can replace the target field content with above calculation.

[OneStop]

Worked perfect thank you!