Rich S Posted January 22, 2009 Share Posted January 22, 2009 Howdy, all: I have about 400 records where each text field begins with a sequential number and has a following instruction, like so: 003. Check, at the aircraft, that it carries an appropriate current airworthiness certificate. 004. Check, at the aircraft, (if required by procedures) for a current and approved Flight Manual for that type of aircraft being operated. ...etc. What I'd like to do is use the Substitute command (or possibly a script) to remove the first five characters in each question so the question number, the following decimal, and the leading space are deleted, leaving the field to begin with the first word of the instruction. I tried using combinations of the Substitute and Left commands but haven't had any luck. What would work? TIA for your help! Rich Link to comment Share on other sites More sharing options...
comment Posted January 22, 2009 Share Posted January 22, 2009 Try: Right ( text ; Length ( text ) - 5 ) Link to comment Share on other sites More sharing options...
Rich S Posted January 22, 2009 Author Share Posted January 22, 2009 Once again, your brilliance illuminates. Thanks!! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5572 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