Jump to content

inconsistent find


mleiser
 Share

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

Recommended Posts

I have records that have a field with values that look like this:

1-1

1-2

1-3

1

KG-1

PB-1

2-1

2-2

1-5

5-1

I'm looking for all the values that start with 1 like 1-1 1 1-3 1-5. If I enter a 1 int the find field, I get all those I'm looking for including KG-1 and PB-1, but NOT 5-1 - all three of which I don't want because they don't start with a 1. Oh yeah, it's a text field. Any help on what I'm doing wrong?

Link to comment
Share on other sites

I don't see how "KG-1" and "PB-1" fit into your condition "I'm looking for all the values that start with 1 like 1-1 1 1-3 1-5." If you don't need those oddballs, you can do the find with:

==1*

Link to comment
Share on other sites

I agree. I don't want those oddballs. My question is why did the results include KB-1 and not 5-1. I really only want any field starting with 1. Something is inconsistent here.

Link to comment
Share on other sites

Hi Michael,

So the word break rules apply?

"one-2" = 2 words

"1-2" = 1 word

I find this subject fascinating and keep a list of these combinations (and exceptions). If anyone else is interested, I suggest Post#176047. Knowing these rules is quite valuable.

L

Edited by Guest
Changed first sentence
Link to comment
Share on other sites

Beautiful. Thanks so much. If I want it to be one word I guess I could make the letter/number combinations without the dash (KB1,1-1,would work). Thanks again.

Mike

Link to comment
Share on other sites

This topic is 5646 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.