Question... I have a customer that we process orders for who's SKU field is a series of characters followed by a space followed by the product's UPC. I need to export SKU and Qty to send to our warehouse for picking via a csv file... is it possible for me to strip away all of the characters preceding the UPC so that field/column in my csv file has only the UPC?
This customer is not willing to remove these characters but they are willing to replace the space with something like an underscore or dash or another unique character if that will help me strip everything but the UPC away.
Thanks for any help.
Please sign in to leave a comment.