PiedPiper Posted June 9, 2004 Posted June 9, 2004 Oh this looks so simple ... I have a field which contains a complete sentence but the very first word is a code ABCDDD (could be text or numbers) then a space then the sentence starts. I want the sentence only. I tried LeftWords(field, 1) + 1. I tried RightWords(field) - LeftWords(field, 1) Good grief. Why is this so difficult for me. I searched LeftWords and got a bunch of examples but none exactly like what I need. I want a calculation that gives just the sentence portion. My mind swims with Position, Pattern Count, MiddleWords, etc and I end up totally blank. I don't like text functions. I decided instead of wasting another five hours just to (again) admit I don't understand how to do it, I'd post. I hope that is alright with you all and I apreciate any help. Pete
-Queue- Posted June 9, 2004 Posted June 9, 2004 Right( field, Length(field) - Position( field, " ", 1, 1 ) ) or RightWords( field, WordCount(field) - 1 ) should work, although the second one will ignore any ending punctuation.
PiedPiper Posted June 9, 2004 Author Posted June 9, 2004 Hi Queue! I used your second one because it actually made sense to me. It was perfect (of course). And yes, I'm working on my text-function learning disability ... Pete
-Queue- Posted June 9, 2004 Posted June 9, 2004 It takes practice to learn how they all work. I still get lost in them myself sometimes, especially when I'm analyzing Ugo's solutions. So don't feel too bad about it.
Recommended Posts
This topic is 7541 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