extracting words after first two

[mcbradford]

I know I am overlooking this, but how do I extract all the words after the first two words. For example - FileMaker cafe is the best tool! I want to extract is the best tool! Please note, the string is never the same (amount of words). What I am doing is bolding the first two words, then the remaining words will be normal.

[MrEase]

try:

MiddleWords ( text ;3; WordCount ( text ) )

[mcbradford]

This is one of my strings...

 

HCl GT 3M, 3N, 25 Wt%

 

Using...

 

Middle( Complete Reagent Name , 3, WordCount( Complete Reagent Name))

 

I get...

 

l GT 3

[Maarten Witberg]

rightwords(string; wordcount(string)-2)

 

will give

 

3M, 3N, 25 Wt

 

without the % sign. probably because % is not recognised by word functions, just like "-"

 

Case(Right(string;1)="%";RightWords(string;WordCount(string)-2)&"%";RightWords(string;WordCount(string)-2))

will stick a % to the result if it's there in the original field. better:

 

Right(string;Length(string)-Position(string;" ";1;2))

 

will leave the % mark in place

 

kjoe

 

ps btw, MiddleWords( Complete Reagent Name , 3, WordCount( Complete Reagent Name))

will work like mrease suggested, but also without the %

[Guest Yukon Cornelous]

[ QUOTE ]

This is one of my strings...

 

HCl GT 3M, 3N, 25 Wt%

 

Using...

 

Middle( Complete Reagent Name , 3, WordCount( Complete Reagent Name))

 

I get...

 

l GT 3

 

[/ QUOTE ]

 

MrEase said MiddleWords( ) not Middle( )

[Maarten Witberg]

You'll loose the % sign using MiddleWords or RightWords. See my post above if that's not acceptable. Also it will count blah-blah as two words so may give faulty results if it should be seen as one.

 

kjoe

[mcbradford]

Thanks Kjoe! Works great

[vinnedb]

Hello,

 

I am new to FM (5.5). We have a FM database that tracks trainer workshop activity and a request has been made to prevent a record from being modified after the workshop has been completed. How can this be done?

 

Thank you for your help!

 

Vince

[-Queue-]

Try creating your own thread instead of hijacking someone else's.

[Maarten Witberg]

he did, here .

[vinnedb]

There's nothing to get excited about. It was an honest mistake! I am new to this forum and I didn't realize I was in your post when I attempted to send one of my own.

[-Queue-]

I noticed that afterwards. So he did both. Can you delete these four posts, as a Moddie?

 

 

Hi -queue-

I can edit in anything or move the post, but I cannot delete, there's no button for it.

[FileMakin' Tom]

Create a duplicate layout upon which no fields are enterable. When a certain condition is met, your data entry script then goes to that layout instead of the enterable one.

 

Tom

[Leader]

Don't worry, vin, Q's not as bad as he seems.

 

At least that's what his parole officer says.

 

(ducking)