Trim(Left) Whole Words

[dztrucktion]

I wish to Trim Left leaving whole words only for a field that has a character limit of 62 characters.

I don't want to have whole words cut off because of the character limitation, for instance: Dog Cat Horse Du should come up with Dog Cat Horse even though it is less than the character limit, I need the complete word.

I am using just the simple Left(field) and it is working fine, it would just be nice to have complete words as incomplete words don't help anyone...

[comment]

Try =

Let ( [

words = WordCount ( Left ( text ; 62 ) ) ;

over = Length ( LeftWords ( text ; words ) ) > 62 

] ;

LeftWords ( text ; words - over )

)

---

Note: Trim() is a Filemaker function, unrelated to the problem.

[Raybaudi]

Divine

[dztrucktion]

Wow, that worked great! Thanks again!

Is this a pretty common function for FM? It seems that all the pieces are there to make it work and I was just un-aware? Is there some dump of info where I could school myself up some FileMaker calculation skills?

Thanks!

[comment]

It seems that all the pieces are there to make it work and I was just un-aware?

Yes, that's how it works. You get mostly very basic functions, and it's up to you to figure out how to put them together to do what you need.

Is there some dump of info where I could school myself up some FileMaker calculation skills?

You should read the help on each function at least once.