Navision to SFDC checking rule
by qwweee7467
JavaScript
// (PATINDEX('%[^'+CHAR(9)+'-'+CHAR(13)+'|!-~|'+char(128)+'-'+char(150)+']%' COLLATE Latin1_General_BIN, [Production Description])
var pattern = '[^ \x09-\x13|!-~|\x80-\x96]';
console.log('TippingPoint 440T + 500Mbps Premium Support'.search(pattern));
console.log('TippingPoint 440T + 500Mbps Premium - Support'.search(pattern));
console.log('TippingPoint X126 1G SFP RJ45 T-Copper Transceiver'.search(pattern));
console.log('TippingPoint 440T + 500Mbps é Premium Support'.search(pattern));
console.log('TippingPoint 440T + 500Mbps Premium ™ Support'.search(pattern));
console.log('TippingPoint 440T + € 500Mbps Premium Support'.search(pattern));