5 Replies Latest reply on Nov 5, 2013 9:03 AM by henryhu91

Perform Find with decimal numbers

henryhu91 Nov 5, 2013 8:13 AM

Title

Post

Hello FMers,

In a field, I've numbers with decimals (100.1) and just numbers itself all mixed up. is there a way I can search only numbers without decimals?

Thanks

1. Re: Perform Find with decimal numbers

philmodjunk Nov 5, 2013 8:21 AM (in response to henryhu91)

Perform a find using this as your search criteria in an "omit" request:

*.*
Like Show 0 Likes(0)

Actions
2. Re: Perform Find with decimal numbers

ninja Nov 5, 2013 8:22 AM (in response to henryhu91)

     I can't think of a way directly, but if you create a calc field set to

     Case( Round(Yourfield; 0) = Yourfield ; "" ; "decimal") result as text

     Then did a find on the calc field for "decimal" you would get it.
Like Show 0 Likes(0)

Actions
3. Re: Perform Find with decimal numbers

henryhu91 Nov 5, 2013 8:46 AM (in response to henryhu91)

     Thanks both of you for taking your time to answer my question.

     @Phil, I have my field as unique so it gives me the validation error. that is not the case. no criteria is matched. so don't find any records even though I have my data that I know for sure have some records with decimals. do you have any thought on that?


     @Ninja thank you. such a brilliant workaround. :)
Like Show 0 Likes(0)

Actions
4. Re: Perform Find with decimal numbers

philmodjunk Nov 5, 2013 8:50 AM (in response to henryhu91)

A unique values validation should not produce such an error message. Perhaps you have also specified that the field is numeric only? That's a known bug.
Like Show 0 Likes(0)

Actions
5. Re: Perform Find with decimal numbers

henryhu91 Nov 5, 2013 9:03 AM (in response to henryhu91)

Bingo. yes it's numeric because I don't want my users to input anything other than numbers. Thanks for the help.
Like Show 0 Likes(0)

Actions

Go to original post