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!

[atcodedog05]

Hi @bsheremeta 

It seems like in formula there is "," comma instead of "." dot. Can you check.

Current:

IIF(CONTAINS("," [txt]), [txt] , "NOPE") 

Required:

IIF(CONTAINS("." [txt]), [txt] , "NOPE") 

[bsheremeta]

Sorry, I just typed it wrong. Actual formula has a .

Edited original post.

[atcodedog05]

Hi @bsheremeta 

The issue is 2482. has been treated as number and converted to number and there by using its "." refer snapshot.

Can you provide a sample file with few entries.

[apathetichell · Accepted solution]

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.

[atcodedog05]

@apathetichell 

Good catch cant believe i missed that 😅🤣