OneStop Posted January 5, 2018 Share Posted January 5, 2018 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 More sharing options...
siroos12 Posted January 5, 2018 Share Posted January 5, 2018 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 More sharing options...
OneStop Posted January 5, 2018 Author Share Posted January 5, 2018 Worked perfect thank you! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now