How to check if values in a cell are numeric or contains only numbers using formula tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
How to check if values in a cell are numeric or contains only numbers using formula tool?
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The isnumber function doesnot seem to be working for me. I have date in the cell that I am looking at in the following format 20200331 (yyyymmdd). I just need to check if the value 20200331 is numeric or not.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you share the workflow or some sample data? I don't seem to be able to reproduce the behavior you describe.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So these are dates parsed in from from a csv file and they show up in the text format. Below are few examples of the dates that I am looking at:
20220228 |
20200331 |
20270220 |
20161001 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The format of data is V_String
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah, if they're coming in as text fields you could try the 'IsInteger' function. That would check if it would be able to be converted to a number. See attached example.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is really helpful. Thank you for guiding me through this!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone,
I want to highlight IsNumber check the field data type, not the value itself
to check if the value is a number use RegEx instead something like this :
REGEX_Match([F], "^-?\d+(\.\d+)?$")
