//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" */
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter