Jump to content

RightWords minus LeftWord??


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

Recommended Posts

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. confused.gif

Pete

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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. wink.gif So don't feel too bad about it.

Link to comment
Share on other sites

This topic is 6437 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
 Share

×
×
  • Create New...

Important Information

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