How to apply regex for getting only numeric values?

[Supriya P]

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]

Fixed the code to show show error message at the bottom of the field.

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

    if (!regexp.test(newValue)) {
		g_form.clearValue('u_effort');
		g_form.showFieldMsg('u_effort', 'It should be numeric fractional entry only', 'error');
    }
}

Execution result:

1. Enter "   5678"

2. Press tab to move to next field.

[Supriya P]

Hi Hitoshi,

We don't want space as shown in screen shot. When we entering space and putting number it is taking space.

We want like this

[Hitoshi Ozawa]

Please paste the script that's being used because it's not taking spaces when I tested it in my PDI. There must be something different that allowing spaces. I'm using Rome too so it's not ServiceNow version that's causing it.

[Hitoshi Ozawa · Accepted solution]

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.