mattc Posted April 21, 2006 Share Posted April 21, 2006 Hi There Can someone help me breifly? What's the best way to trim text between quotes in a text field: "test text" xyz123 returns just test text I am having problems with positioning & substitution with the quotes! Thanks Link to comment Share on other sites More sharing options...
Krioni Posted April 21, 2006 Share Posted April 21, 2006 What's the best way to trim text between quotes in a text field: "test text" xyz123 returns just test text Well, there are many ways to do this, including use the Let function, a Custom Function (if you have Advanced), etc. Here's one way that works: Middle( SomeTextField ; Position( SomeTextField; """; 1; 1) +1 ; Position( SomeTextField; """; 1; 2) - Position( SomeTextField; """; 1; 1) -1 ) Where SomeTextField is your source text. Also, you'll guess that you could do the same for any other substring. Note: this will find the FIRST double-quote character and get text between that and the SECOND double-quote character. If you wanted to get multiple quoted pieces from one string you'd need a lot more code. At that point, you'd certainly want to use the Let function or a Custom Function. Link to comment Share on other sites More sharing options...
mattc Posted April 21, 2006 Author Share Posted April 21, 2006 Thanks very much! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6573 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