Omit decimals in find request...

[dhsa21]

This should be easy for you guys.... I use case numbers like 12-2222.  If I have an addition to the case it gets a two digit decimal like 12-2222.22.  I want to find all cases without decimals.  For instance I want to find 12-2222 but not 12-2222.22.  How do I do this???

Also, the case numbers may be only 5 digits like 17-888 and I would need to find them without the decimals also, like do not find 17-888.22

 

[comment]

Doesn't this answer work for you?

 

[dhsa21]

Thanks for the answer, but this still returns the cases with decimal numbers

If it helps, the “case no” field I’m working with is a text field.

[comment]

14 minutes ago, dhsa21 said:

this still returns the cases with decimal numbers

It doesn't when I try it - see the attached file.

ExactWordFind.fmp12

[dhsa21]

I can't thank you enough for your responses, I need to take it a step further though.  If I add a field to your database like "client name" and then I want to search for that client name and all cases without decimals in them, how is this done, keeping in mind that some of my case numbers are also formatted with XX-XXX and some XX-XXXX.  Any ideas?

 

[LaRetta]

One way to find all records without decimal is:

Enter Find Mode []

Set Field [ your field ] ;  "*.*"

Perform Find

Show Omitted Only

 

Michael explained the basics in the post referenced to me.  😄

[dhsa21]

that works!!!!!!!!!!! THANKS THANKS THANKS!!!

[comment]

7 hours ago, dhsa21 said:

I want to search for that client name and all cases without decimals in them, how is this done,

I would do it like this:

Enter Find Mode [ ]
Set Field [ YourTable::ClientName; $searchClient ] 
New Record/Request
Set Field [ YourTable::CaseNumber; "*.*" ]
Omit Record
Perform Find [ ]

where $searchClient is the client name you are looking for.
 

---
P.S. Please update your profile with your current version.

 

Edited September 6, 2024 by comment