Jump to content

Removing Characters Past X


This topic is 2274 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2274 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.