Validation for numeric values in AX

(0) Share

Report

Posted on by syed baber

11,633

Hi All,

I am importing some data from csv file. I need to validate some columns where the values should be numeric. I need to check the value if it is not numeric, then I need to throw an error. Is there an easy way in X++ to do this? I am using the below method, but it is returning false in case of real values:

boolean isNumeric(str strToValidate)
{
boolean ok = true;
;

ok = (strlen(strToValidate)) == strlen(strkeep(strToValidate,'1234567890'));

return ok;
}

Thanks,

Baber.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (3)

Sort by

Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

it is because, a real number will have . (decimal) also in the string

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

so your function will be something like this

boolean isNumeric(str strToValidate)

{

boolean ok = true;

;

ok = (strlen(strToValidate)) == strlen(strkeep(strToValidate,'1234567890.'));

return ok;

}

please verify and update if this fix your issue

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report
Copy link

Link copied!

Yes I know this is the reason, so is there any other way to do this?

Thanks,

Baber.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

yes, you should try the modified function which I have posted

Was this reply helpful? Yes No
syed baber 11,633 on at

Like (0)

Report
Copy link

Link copied!

Thanks Nitesh for fast response.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 240,196 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Also don't forget that real values may be negative (character "-"), some countries use comma as the decimal mark and potentially there may be other things like a thousands separator.

The implementation depends on what exactly you want to achieve (or which cases you decide to ignore). One possible alternative is using System.Single::TryParse(strToValidate, byref yourNumber).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hay,

You can use the function isInteger(abcdx).

Thanks

Shahid

Was this reply helpful? Yes No
Suggested answer

MC08 170 on at

Like (0)

Report
Copy link

Link copied!

I encounter similar requirement today and i tested following function can't handle if the value from string is like "1.1.1"

boolean isNumeric(str strToValidate)

{

boolean ok = true;

;

ok = (strlen(strToValidate)) == strlen(strkeep(strToValidate,'1234567890.'));

return ok;

}

I used below function which using regular expression instead, it can handle the case mentioned above and also negative situation.

public static boolean isDecimals(str _value)

{

System.Text.RegularExpressions.Match myMatch;

System.Text.RegularExpressions.Regex regex;

;

regex = new System.Text.RegularExpressions.Regex(@'^-?(([1-9][0-9]*)|(0))(?:\.[0-9]+)?$');

myMatch = regex.Match(_value);

return myMatch.get_Success();

}

Was this reply helpful? Yes No