How can i know if a field contains only numeric values ?

[#1]

I have a problem: i must know if a alphanumeric field contains only numeric value or not.

Please help me

Thanks

Claudio

[Gysbert_Wassenaar]

Add a Statistics Box object for the field and add the Numeric Count and Text Count statistics. Then check those counts.

[Anonymous]

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

[Anonymous]

Hi try this

IsNum( expr )

Returns -1 (true) if the expression can be interpreted as a number, otherwise 0 (false).

Regards

Harsha

[#5 · Accepted solution]

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

[#6]

Ok, I use the first:

=IF (IsNum( Warehouse_Map.DS_COLUMN),right('000' & Warehouse_Map.DS_COLUMN,3),Warehouse_Map.DS_COLUMN)

Thanks,

Claudio

[#7]

Hi Claudio,

Could you close this discussion , if you find the same as helpful  or correct.

Regards,

Joshmi