Contains Formula

bsheremeta

I have a column called 'TXT' and I would like to search through all the data in that column to check for numbers that have . in them. 

For example:

2329

23842

2482. 

The output should be 

Nope

Nope

2482.

I tried:

IIF(CONTAINS("." [txt]), [txt] , "NOPE") but that doesn't seem to work. Most likely the problem is with "." How can I achieve this?

Thank you!

apathetichell

contains is a string function and depending upon how your column is set up you may be trying to perform a numeric search with it... to search inside of number for numbers with decimals you can use something like contains(tostring([mynumber[),".")

also the format for contains is contains([column with "2482",".") not contains(".","2482") search term is second. You are searching if "2482." is in "." not vice versa.