Dear all,
I have a text value in which I put what the scanner reads... However, even if the value coded with the barcode is a 8 digit, sometimes I have alphanumeric values inside my text... How can I check the value is really a numeric ?
Thanks for your help.
Kim
Seems like you could use EXTRACTNUMBERS(text-to-extract-from) and then if needed you could compare with the original to see if there were non-numeric values in the text-to-extract-from
Hi Kim,
You can also use the NUMBER function to convert text to a number. This will fail if the text has any non-numeric characters, so you can then check if the result was not blank (meaning it succeeded):
ISNOTBLANK(NUMBER([Scanned Text Value]))
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |