Hello! How can I run a search to pull all data tha...
# suiteanalytics
k
Hello! How can I run a search to pull all data that has a value which is not an integer in a certain field?
g
You mean checking if a number is something like 4.25 vs. 4? Maybe you could add a formula in criteria such as:
CASE WHEN {fieldname} != TRUNC({fieldname}) THEN 1 ELSE 0 END
And then set the criteria for 1. The conversion to integer using TRUNC might not work all the time, but you could also try TO_NUMBER or CAST.
k
I have a custom field for tracking numbers which is populated by the EDI. the tracking number values should only be alpha-numeric, I want to get all those records that have anything other than tracking number. Sorry my initial request was not accurate. I thought tracking numbers were only integers, but looks like characters could be there as well.