I'm working with the Salesforce data and looking to extra some data (as much as I can) from opportunity names.
Attached is a sample data set. From a given opportunity, I'd like to extract the Product and Qty if it is a NAL opportunity (we have the type column to help with that), for a Subscription it's always 1, and for upgrades many of the opportunities (but not all) have a from to to part of the string, which should be able to determine that From - To == QTY. Upgrades often have product in there too.
I also want to remove non-english characters from the name as part of the regex.
Thanks.
