Carey Brown wrote:
Do you mean, leave the spaces preceding the 'S' but remove only the 'S'?
Yes. Or remove spaces and "S".
Any character in the
string that has a preceding space, I need to remove it.
Reason, the suffix is not a part of the Customer Part Number.
It is used internally within our ERP system to define certain attributes like routing process.
However, when the part number is referenced on any document going back to the Customer the suffix needs to be removed.