Bringing this one back from the dead (Glad to see I’m getting to something that bothered me 5 years ago!).
We run the ‘Update Trailing Spaces’ user run conversion monthly, but I’d like to prevent it in the first place.
How do I add TRIM () to my Part in-trans data directive to trim leading and trailing spaces? I’m not sure how to set up the syntax to do everything. Just add .Trim() after? Or make it a second line? Or something else? Safe to do? Will it break bar code scanners (I can’t image folks loading new part numbers that way…)
ttPartRow.PartNum.ToUpper().Trim()
OR
ttPartRow.PartNum.ToUpper()
ttPartRow.PartNum.Trim()
@Chris_Conn - Found your response to this thread: Strip out spaces from tracking number - #9 by Chris_Conn
I just created the BPM to force upper case, which works like a charm:
