To remove white spaces from a field

[Poorva Bhawsar]

Hi Community,

I have a BR using which i am removing the spaces from a field. First the data is getting being loaded via scheduled job. Once its loaded an after insert/update BR will work and it will remove the spaces from that field.

Here is the code, i thought it was working fine in background script but now it didnt removed spaces from 2 records.

var record = new GlideRecord('xyz');

    record.query();

    while (record.next()) {

        record.abc = record.abc.toString().replace('ABCD', '');

        record.abc = record.abc.toString().replace(/ /g, '');

        record.setWorkflow(false); //Do not run business rules

        record.autoSysFields(false); //Do not update system fields

        record.update();

    }

Let me know is there any change required in the code and why it didnt removed spaces for 2 records.

Thanks

[Runjay Patel]

Hi @Poorva Bhawsar ,

Try using below code.

var record = new GlideRecord('xyz');
record.query();

while (record.next()) {
    if (record.abc) { // Ensure the field is not null
        var updatedValue = record.abc.toString()
            .replace(/ABCD/gi, '') // Case-insensitive removal of 'ABCD'
            .replace(/ /g, '');    // Remove all spaces

        // Update only if there's a change to prevent redundant saves
        if (record.abc.toString() !== updatedValue) {
            record.abc = updatedValue;
            record.setWorkflow(false); // Skip business rules
            record.autoSysFields(false); // Skip system field updates
            record.update();
        }
    }
}

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------