Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem: i must know if a alphanumeric field contains only numeric value or not.
Please help me
Thanks
Claudio
Hi,
You can use the below script in script level or in Chart.
1. if(Isnum(FieldName),'Num','Text')
or
2. if(IsText(FieldName),'Text','Num')
Regards,
Joshmi
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
if (purgechar(yourstring,'0123456789ABCDEF')='',1,0)
1: only alphanumeric
0: other characters
Hi,
You can use the below script in script level or in Chart.
1. if(Isnum(FieldName),'Num','Text')
or
2. if(IsText(FieldName),'Text','Num')
Regards,
Joshmi
Ok, I use the first:
=IF (IsNum( Warehouse_Map.DS_COLUMN),right('000' & Warehouse_Map.DS_COLUMN,3),Warehouse_Map.DS_COLUMN)
Thanks,
Claudio
Hi Claudio,
Could you close this discussion , if you find the same as helpful or correct.
Regards,
Joshmi