
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How can i know if a field contains only numeric values ?
I have a problem: i must know if a alphanumeric field contains only numeric value or not.
Please help me
Thanks
Claudio
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Add a Statistics Box object for the field and add the Numeric Count and Text Count statistics. Then check those counts.
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ok, I use the first:
=IF (IsNum( Warehouse_Map.DS_COLUMN),right('000' & Warehouse_Map.DS_COLUMN,3),Warehouse_Map.DS_COLUMN)
Thanks,
Claudio

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Claudio,
Could you close this discussion , if you find the same as helpful or correct.
Regards,
Joshmi
