I am trying to parse the Serial / Lot Number field on an after submit client script applied to Item Receipts. Basically I want to create a custom record for each serial number entered.
I am haveing some difficulties extracting the serial numbers from that field. I am trying to use a regexp and .split() to extract them and populate an array.
BTW the extra were removed by the forum when I posted. The expression is /^w+s*w*/;
var re = /^w+s*w*/; var lines = nlapiGetLineItemCount('item'); for (var i = 1; i <= lines; i++) { .... var serial = nlapiGetLineItemValue('item', 'serialnumbers', i); var seriallist = serial.split(re); for (var j=0; j<=seriallist.length; j++) { var termrec = nlapiCreateRecord('customrecordterminal'); termrec.setFieldValue('name', seriallist[j]); .... Trouble is I always end up with an extra square character (I can't figure out how to type it) before each number after the first. I assume this is the line break between the numbers, but I can't figure out how to strip it out. This character causes an unexpected error when I try to pass the value to my custom record. I have not used regular expressions very much, so I may be doing something stupid. Or maybe there is an easier way? Has anyone else tried to extract the values from this field? Any insight would be appreciated. Thanks as always!