Filtering down to one word

[LaRetta]

I just realized my newly established theory from a month ago (plan ahead for contingency and factor into my calculations) is incorrect also. Because if we always plan for 'what ifs' our solutions might not be optimum.

I think I'll modify my theory to more of, "If you are SURE it will always start with ... then ... BUT if it ever changes ..." etc etc. I'm also finding myself wanting to get everything in writing that we agree upon because it's come back and bit me a few times.

And it isn't your job to run around behind us making sure we post the best answers but, oh, I dearly love to have my work fine-tuned. I recognize that most people would need to pay big bucks for the kind of consultation we all receive for free. I doubt ANY of my calculations would ever be optimum, JT, unless it's a simple If().

"... I'm playing a video game, watching a movie, or reading a Dean Koontz book "

Intensity. Best book ever. My kinda book!! Or you could be makin' music! God, can you sing!

LaRetta

[-Queue-]

Lightning, False Memory, Odd Thomas, Phantoms, Strangers--I have too many favorites to quantify any as the best book ever. The man does need to stop writing until I have a chance to catch up on the last 40 years though. Sheesh!

If I'm making music now, it's only on the drums. I have no inclination to sing after a few hours of doing that. Maybe someday I will again though...

[-Queue-]

Lightning, False Memory, Odd Thomas, Phantoms, Strangers--I have too many favorites to quantify any as the best book ever. The man does need to stop writing until I have a chance to catch up on the last 40 years though. Sheesh!

If I'm making music now, it's only on the drums. I have no inclination to sing after a few hours of doing that. Maybe someday I will again though...

[-Queue-]

Lightning, False Memory, Odd Thomas, Phantoms, Strangers--I have too many favorites to quantify any as the best book ever. The man does need to stop writing until I have a chance to catch up on the last 40 years though. Sheesh!

If I'm making music now, it's only on the drums. I have no inclination to sing after a few hours of doing that. Maybe someday I will again though...

[Heathbo]

Would patterncount be better if a few of the colors where Yellow Green, and Grass Green? Where the word green is the second word in the name. Or would LeftWords be better?

[Heathbo]

Would patterncount be better if a few of the colors where Yellow Green, and Grass Green? Where the word green is the second word in the name. Or would LeftWords be better?

[Heathbo]

Would patterncount be better if a few of the colors where Yellow Green, and Grass Green? Where the word green is the second word in the name. Or would LeftWords be better?

[-Queue-]

If the first word always signifies the color, then LeftWords would be fine. If you have an instance such as Yellow Green, and Green is the color, then it will not work. If Yellow is the color, then it would. If you use a Case with PatternCount, you'll have an issue determining the hierarchy of colors. If you test for Green before Yellow, the result will be Green. If you test for Yellow before Green, the result will be Yellow.

It's seems that the most reliable structure would be to include signifying color before description or other color and then to use LeftWords. Yellow Green would then produce Yellow and Green Yellow would produce Green. Grass Green would have to be changed to Green Grass so that Grass isn't returned as a color. If this isn't an option for you, you could use a combination of LeftWords and PatternCount.

Let( C = LeftWords( colorField; 1 );

Case( Position( " red orange yellow green blue indigo violet "; " " & C & " "; C; PatternCount( " " & colorField & " "; " red " ); "red"; PatternCount( " " & colorField & " "; " orange " ); "orange"; ... ) )

Again, this wouldn't be foolproof unless combination colors such as Yellow Green were defined with the signifying color listed first. Grass Green would be fine since it only contains one color, which would be identified after the Position test portion of the Case failed and the 'green' test was successful.

[-Queue-]

If the first word always signifies the color, then LeftWords would be fine. If you have an instance such as Yellow Green, and Green is the color, then it will not work. If Yellow is the color, then it would. If you use a Case with PatternCount, you'll have an issue determining the hierarchy of colors. If you test for Green before Yellow, the result will be Green. If you test for Yellow before Green, the result will be Yellow.

It's seems that the most reliable structure would be to include signifying color before description or other color and then to use LeftWords. Yellow Green would then produce Yellow and Green Yellow would produce Green. Grass Green would have to be changed to Green Grass so that Grass isn't returned as a color. If this isn't an option for you, you could use a combination of LeftWords and PatternCount.

Let( C = LeftWords( colorField; 1 );

Case( Position( " red orange yellow green blue indigo violet "; " " & C & " "; C; PatternCount( " " & colorField & " "; " red " ); "red"; PatternCount( " " & colorField & " "; " orange " ); "orange"; ... ) )

Again, this wouldn't be foolproof unless combination colors such as Yellow Green were defined with the signifying color listed first. Grass Green would be fine since it only contains one color, which would be identified after the Position test portion of the Case failed and the 'green' test was successful.

[-Queue-]

If the first word always signifies the color, then LeftWords would be fine. If you have an instance such as Yellow Green, and Green is the color, then it will not work. If Yellow is the color, then it would. If you use a Case with PatternCount, you'll have an issue determining the hierarchy of colors. If you test for Green before Yellow, the result will be Green. If you test for Yellow before Green, the result will be Yellow.

It's seems that the most reliable structure would be to include signifying color before description or other color and then to use LeftWords. Yellow Green would then produce Yellow and Green Yellow would produce Green. Grass Green would have to be changed to Green Grass so that Grass isn't returned as a color. If this isn't an option for you, you could use a combination of LeftWords and PatternCount.

Let( C = LeftWords( colorField; 1 );

Case( Position( " red orange yellow green blue indigo violet "; " " & C & " "; C; PatternCount( " " & colorField & " "; " red " ); "red"; PatternCount( " " & colorField & " "; " orange " ); "orange"; ... ) )

Again, this wouldn't be foolproof unless combination colors such as Yellow Green were defined with the signifying color listed first. Grass Green would be fine since it only contains one color, which would be identified after the Position test portion of the Case failed and the 'green' test was successful.

[Ugo DI LUCA]

Hi,

At the end, you'd better build a value list based on some other Table with a construction of type :

- serial

- full : Yellow Green

- color : Green

[Ugo DI LUCA]

Hi,

At the end, you'd better build a value list based on some other Table with a construction of type :

- serial

- full : Yellow Green

- color : Green

[Ugo DI LUCA]

Hi,

At the end, you'd better build a value list based on some other Table with a construction of type :

- serial

- full : Yellow Green

- color : Green