How to apply regex for getting only numeric values?

Supriya P · ‎01-10-2022

Hi,

I have a requirement, on "Change Request" there is field Effort Estimation "Type : String". In that field only numeric value should be filled eg: 23.55, 345, 56. For that I have written a onChange client script. Values like ASdsf233 and asd.345 are cleared But it is taking value "123Asfdg" ,"456.fgj" How to clear values like 65768Asdgf.

Client script:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}

var regexp = /^[0-9].*$/;

if (!regexp.test(newValue))
{
alert('It should be numeric fractional entry only');

g_form.setValue('u_effort', '');
}
}

Hitoshi Ozawa · ‎01-11-2022

Another option is to trim the spaces and test the trimmed value.

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    var regexp = /^[0-9]*(.)?[0-9]*$/; // may or may not have fractional. Fractional should also be numeric
	var str = newValue.trim(); // trim leading and ending spaces
    if (!regexp.test(str)) {
		g_form.clearValue('u_effort');
		g_form.showFieldMsg('u_effort', 'It should be numeric fractional entry only', 'error');
    } else if (str != newValue) {  // if there was leading or ending spaces, set the value to trimmed value
		g_form.setValue('u_effort', str);
	}
}

Execution result.

1. Enter " 5678 "

2. Press tab key.

View solution in original post

Anil Lande · ‎01-10-2022

Hi,

Please check below link and use one fitting your requirement.

https://stackoverflow.com/questions/308122/simple-regular-expression-for-a-decimal-with-a-precision-...

Thanks,
Anil Lande

Please appreciate the efforts of community contributors by marking appropriate response as correct answer and helpful, this may help other community users to follow correct solution in future.
Thanks
Anil Lande

Hitoshi Ozawa · ‎01-10-2022

Why use regular expression.

if (isNaN(newValue)) {
  alert('It should be numeric fractional entry only');
  g_form.setValue('u_effort', '');
}

Supriya P · ‎01-10-2022

Thank You Hitoshi it is working for me now.

Community Alums · ‎07-21-2022

Hitoshi,

Using isNan allows the mathematical constant e

Field will have values like 1e1, 1000e344 etc