Search a value with incorrect spaces
Mon Mar 15 2021 18:06:36 GMT+0000 (UTC)
Saved by
@nhord2007@yahoo.com
#servicenow
#search
#javascript
//Search a value with incorrect spaces..
var input = 'gu ara nteed rate';
var table = 'core_company';
var field = 'name';
var searchName = input.replace(/\s/g, '').toLowerCase();
var gr = new GlideRecord(table);
gr.addEncodedQuery(field + 'ISNOTEMPTY');
gr.query();
while (gr.next()) {
var fieldString = gr.getValue(field).replace(/\s/g, '').toLowerCase();
if (fieldString.indexOf(searchName) != -1)
gs.info('FOUND: "' + gr[field].getDisplayValue() + '"');
}
/*
Example:
2021-03-15T18:05:40.674Z: FOUND: "Guaranteed Rate Insurance"
2021-03-15T18:05:40.677Z: FOUND: "Guaranteed Rate, Inc2"
2021-03-15T18:05:40.678Z: FOUND: "Guaranteed Rate, Inc."
2021-03-15T18:05:40.680Z: FOUND: "Guaranteed Rate, Inc"
2021-03-15T18:05:40.682Z: FOUND: "Guaranteed Rate Affinity"
*/
content_copyCOPY
Comments