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!
Solved! Go to Solution.
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")
Sorry, I just typed it wrong. Actual formula has a .
Edited original post.
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.
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.