I have a problem: i must know if a alphanumeric field contains only numeric value or not.
Please help me
Add a Statistics Box object for the field and add the Numeric Count and Text Count statistics. Then check those counts.
try to work with purgechar
you may convert your field to upper case string
1: only alphanumeric
0: other characters
Hi try this
Returns -1 (true) if the expression can be interpreted as a number, otherwise 0 (false).
You can use the below script in script level or in Chart.
Ok, I use the first:
=IF (IsNum( Warehouse_Map.DS_COLUMN),right('000' & Warehouse_Map.DS_COLUMN,3),Warehouse_Map.DS_COLUMN)
Could you close this discussion , if you find the same as helpful or correct.
Retrieving data ...